Processos Seletivos abertos - Consulta
SELECT * FROM FUNCAMP.PSCT001 PS1, funcamp.psct002 ps2, funcamp.psct003 ps3 WHERE PS1.DTENCERRAMENTO IS NULL AND PS1.FLSTATUS = 'A' AND PS1.DTINIENTCURRICULO IS NULL AND PS1.DTFIMENTCURRICULO IS NULL AND PS1.NREDITAL NOT IN ( SELECT DISTINCT PS6.NREDITAL FROM FUNCAMP.PSCT006 PS6, FUNCAMP.PSCT005 PS5 WHERE PS6.CDCANDIDATO = PS5.CDCANDIDATO AND PS6.NRANO = PS1.NRANO AND PS6.NRANO = PS5.NRANO AND PS5.NRETAPA IN (1,2,3,4) ) AND ps3.nredital = ps1.nredital AND ps3.nrano = ps1.nrano AND ps2.cdfuncao = ps3.cdfuncao UNION SELECT * FROM FUNCAMP.PSCT001 PS1, funcamp.psct002 ps2, funcamp.psct003 ps3 WHERE PS1.DTINIENTCURRICULO IS NOT NULL AND PS1.DTFIMENTCURRICULO IS NOT NULL AND PS1.DTINIENTCURRICULO <= trunc(SYSDATE) AND NVL(PS1.DTPRORROGACAO, PS1.DTFIMENTCURRICULO) >= trunc(SYSDATE) AND PS1.DTENCERRAMENTO IS NULL AND PS1.FLSTATUS = 'A' AND ps3.nredital = ps1.nredital AND ps3.nrano = ps1.nrano AND ps2.cdfuncao = ps3.cdfuncao
