SELECT vw
FROM ViewAgencia vw
    LEFT JOIN (
    	SELECT inag.idIndispAgend
    	FROM IndisponibilidadeAgendamento inag
    		JOIN IndisponibilidadeServicoPrevidencia isep ON ( inag.idIndispAgend = isep.idIndispAgend )
    	WHERE (
                ( :flDtFimIndispNull = 'N' AND FUNC( 'TRUNC', inag.dtInicIndisp ) BETWEEN FUNC( 'TRUNC', FUNC( 'TO_DATE', :dtInicIndisp, 'YYYY-MM-DD' ) ) AND FUNC( 'TRUNC', FUNC( 'TO_DATE', :dtFimIndisp, 'YYYY-MM-DD' ) ) ) OR
                ( :flDtFimIndispNull = 'N' AND FUNC( 'TRUNC', inag.dtFimIndisp  ) BETWEEN FUNC( 'TRUNC', FUNC( 'TO_DATE', :dtInicIndisp, 'YYYY-MM-DD' ) ) AND FUNC( 'TRUNC', FUNC( 'TO_DATE', :dtFimIndisp, 'YYYY-MM-DD' ) ) ) OR
                FUNC( 'TRUNC', inag.dtInicIndisp ) >= FUNC( 'TRUNC', FUNC( 'TO_DATE', :dtInicIndisp, 'YYYY-MM-DD' ) ) AND :flDtFimIndispNull = 'S'
            )
        	AND inag.flHabilt = 'S'
            AND (
			    ( inag.flPeriodIntegr = 'N' AND inag.dtHrInic BETWEEN :dtHrInic AND :dtHrFim OR inag.dtHrFim BETWEEN :dtHrInic AND :dtHrFim )
			    OR inag.flPeriodIntegr = 'S' OR :flPeriodIntegrTela = 'S'
        	)
        	AND isep.idTipoServicPrevid IN ( :idTipoServicPrevidList )
    ) virtual ON ( vw.idUnidAdmin = virtual.idUnidAdmin )
WHERE virtual.idIndispAgend IS NULL