Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- FREF.FREF_ID_REGIST_FUNCNL ,
- FREF.FUVI_ID_FUNC_VINC ,
- FREF.EVEN_ID_EVENTO ,
- FREF.FREF_DS_ORIGEM ,
- FREF.CLFU_ID_CLASSE_FUNCNL ,
- FREF.FREF_DS_PUBLIC ,
- FREF.FREF_DT_PUBLIC ,
- FREF.FREF_DT_POSSE ,
- FREF.FREF_DT_VALID ,
- FREF.FREF_CD_PROCES ,
- FREF.FREF_DS_FUNDMT ,
- FREF.FREF_DT_APARTIRDE ,
- FREF.FREF_DS_PROVEN ,
- FREF.FREF_DS_PROVEN_REFIXA ,
- FREF.FREF_DS_BENEFC ,
- FREF.FREF_DT_ATO ,
- FREF.FREF_DT_FALEC ,
- FREF.SIFU_ID_SITUAC_FUNCNL ,
- FREF.FREF_DT_INIC_SITUAC ,
- FREF.FREF_DT_TERM_SITUAC ,
- FREF.FREF_IN_READAP ,
- FREF.FREF_NU_READAP_PRAZO ,
- FREF.FREF_IN_PRAZO_OP ,
- FREF.FREF_DT_INIC_FORMA ,
- FREF.FREF_DT_TERM_FORMA ,
- FREF.FREF_FL_SEM_EFEITO ,
- FREF.FREF_FL_RETIFIC ,
- FREF.FREF_FL_PORTE_ARMA ,
- FREF.FREF_DS_OBS ,
- FREF.FREF_FL_SITUAC ,
- FREF.USUA_ID_USU_INCL ,
- FREF.FREF_DT_INCL ,
- FREF.USUA_ID_USU_ULT_ALTER ,
- FREF.FREF_DT_ULT_ALTER ,
- FREF.FREF_NM_ARQ_REGIST_FUNCNL
- FROM GEF_FUNCIONARIO FUNC
- JOIN GEF_FUNCIONARIO_VINCULO FUVI ON (FUNC.FUNC_ID_FUNC = FUVI.FUNC_ID_FUNC)
- JOIN GEF_FICHA_REGISTRO_FUNCIONAL FREF ON (FUVI.FUVI_ID_FUNC_VINC = FREF.FUVI_ID_FUNC_VINC)
- LEFT JOIN GEF_EVENTO EVEN ON (FREF.EVEN_ID_EVENTO = EVEN.EVEN_ID_EVENTO)
- JOIN GEF_CLASSE_FUNCIONAL CLFU ON (FREF.CLFU_ID_CLASSE_FUNCNL = CLFU.CLFU_ID_CLASSE_FUNCNL)
- WHERE (1=1
- AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
- AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (32) -- Oficial de Cartório Policial 5ª Classe
- AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')))
- AND FUVI.FUVI_ID_FUNC_VINC NOT IN(
- SELECT FREFW.FUVI_ID_FUNC_VINC FROM GEF_FICHA_REGISTRO_FUNCIONAL FREFW
- WHERE (FREFW.EVEN_ID_EVENTO IN (2,5,33)
- AND FREFW.FREF_DT_POSSE > FREF.FREF_DT_POSSE)
- -- AND FREFW.CLFU_ID_CLASSE_FUNCNL IN (31)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement