API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 70.80 KB | None | 0 0
raw download clone embed print report
  1. SELECT * FROM GEF_FICHA_REGISTRO_FUNCIONAL FREF WHERE (FREF.EVEN_ID_EVENTO IN (2,5,33) AND FREF.FREF_DT_POSSE > TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) AND FUVI_ID_FUNC_VINC IN (
  2. SELECT DISTINCT
  3. FUVI.FUVI_ID_FUNC_VINC
  4. FROM GEF_FUNCIONARIO FUNC
  5. JOIN GEF_FUNCIONARIO_VINCULO FUVI ON (FUNC.FUNC_ID_FUNC = FUVI.FUNC_ID_FUNC)
  6. JOIN GEF_FICHA_REGISTRO_FUNCIONAL FREF ON (FUVI.FUVI_ID_FUNC_VINC = FREF.FUVI_ID_FUNC_VINC)
  7. LEFT JOIN GEF_EVENTO EVEN ON (FREF.EVEN_ID_EVENTO = EVEN.EVEN_ID_EVENTO)
  8. JOIN GEF_CLASSE_FUNCIONAL CLFU ON (FREF.CLFU_ID_CLASSE_FUNCNL = CLFU.CLFU_ID_CLASSE_FUNCNL)
  9. WHERE (1=1
  10. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  11. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 4 -- Perito Legista 1ª Classe
  12. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  13. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('292059-5','323271-4','292354-8','292201-3','292115-3','292160-4','292078-1','55354-6','292171-0','299959-6','323165-6','2921694-0','323287-3','292164-1','299890-6','299918-4','323293-1','299723-8','2997432-1','299048-1','2990592-3','2928355-8','292219-5','2998955-8','2921517-0','2921227-8','2992846-0','2997954-4','2920942-0','3234577-1','299815-8','292153-5','299750-1','2997264-7','3002394-7','2997653-7','299764-6','299801-8','890416-2','2922177-3','2928380-9','2037881-5','2990601-6','2928267-5','2928297-7','2952096-7','2037073-3','3235276-0','2921386-0','2998105-0','2997158-6','2998501-3','2922124-2','2922276-1','2997897-1','554070-4','2921671-0','3233885-6','2997215-9','299962-4','2921627-3','299897-3','3235456-8','3235716-8','2444438-3','3232820-6','3232707-2','2928348-5','3235196-8','2036286-2','2998485-8','2998393-2','2035454-1','2921455-6','2920832-7','2990543-5','2921885-3','2928405-8','2921367-3','2997966-8','2992735-8','2998513-7','3232892-3','2998665-6','2990444-7','2998462-9','3229581-2','564646-4','2443364-0','2922287-7','2998048-8','2918823-7','2921855-1','2927923-2','2998676-1','2997936-6','4137787-7','2927953-4','2998455-6','2952025-8','2035836-9','554075-5','3235106-2','3233984-4','2918864-4','2998184-0','566055-6','2923444-1','2997393-7','2921344-4','2920965-0','2921188-3','2923493-0','2997844-0','3234635-2','2928318-3','2997584-0','564689-8','3005193-2')
  14.  
  15. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  16. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 5 -- Perito Legista 2ª Classe
  17. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  18. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2117034-7','2918701-0','2922165-0','2920466-6','2928095-8','2990205-3','2920885-8','562763-0','2921752-0','2923550-2','2036325-7','2035767-2','2998055-0','3235154-2','2921793-8','554749-0','2920995-1','2922135-8','3234658-1','564684-7','564702-9','3159257-0','564687-1','564639-1','564638-3','564637-5','3864966-7','564675-8','564640-5','564641-3','3008767-8','3047165-6','564642-1','564700-2','550290-0','564651-0','3056993-1','3146944-2','564668-5','570894-0','2978224-4','1986744-1','549164-9','563431-8','564704-5','563647-7','564711-8','564722-3','564650-2','564720-7','564695-2','564653-7','564649-9','570897-4','4177277-6','4177281-4','3031616-2','3013476-5','3113745-8','564644-8','564679-0','564713-4','564705-3','564660-0','564654-5','2043233-0','2009486-8','564708-8','564671-5','564681-2','564656-1','563812-7','564662-6','4177279-2','3013465-0','564664-2','4137788-5','563935-2','564663-4','564721-5','564667-7','3123224-8','565994-9','566015-7','3235605-6','4177282-2','4177267-9','564690-1','611789-9','564676-6','564683-9','564718-5','3197315-9','564706-1','1976632-7','4137789-3','2027964-7','564680-4','564692-8','564677-4','564661-8','564710-0','564686-3','564670-7','564714-2','564673-1','570896-6','4136467-8','4177278-4','4137712-5','549738-8','3066732-1','564643-0','564707-0','564709-6','3047715-8','564724-0','570893-1','4178845-1','3228691-0','564717-7','564719-3','564727-4','564672-3','4137793-1','564723-1','3160730-6','4138369-9','2444986-5','2999734-8','3020637-5','3235444-4','4177275-0','4177276-8','4177266-0','2444063-9')
  19.  
  20. --AND (FREF.EVEN_ID_EVENTO IN (1,5,27,28) -- Posse, Enquadramento, Admissão ou Nomeação
  21. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 6 -- Perito Legista 3ª Classe
  22. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  23. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('3141873-2','4136344-2','564693-6','564659-6','564691-0','570892-3','565993-0','564652-9','4178846-0','3014233-4','3031414-3','550078-8','4177269-5','4177272-5','3014226-1','1977206-8','615296-1','4177268-7','4177271-7','553289-2','3015436-7','5009980-9','5009989-2','5009990-6','5009991-4','5009982-5','5009992-2','5009993-0','1983521-3','5009996-5','5009999-0','5009978-7','5010001-7','5010003-3','5010006-8','5010012-2','5010018-1','5010021-1','5010044-0','4277600-7','5010049-1','4374538-5','4351148-1','5009977-9','615140-0','5009976-0','564931-5','5010061-0','5010064-5','5010065-3','5010008-4','5009981-7','5023006-9','435111-9')
  24.  
  25. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  26. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 7 -- Perito Criminal 1ª Classe
  27. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  28. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2968135-9','2966905-7','2967326-7','2940761-3','2968973-2','2969117-6','2948277-1','2966374-1','2967906-0','2968418-8','2969532-5','2969394-2','2968315-7','2969097-8','2968393-9','2968695-4','4073098-0','2968996-1','2969822-7','2969624-0','2951595-5','2968893-0','2966215-0','2969382-9','2968642-3','2969258-0','2036917-4','553544-1','2967462-0','2969189-3','2965035-6','2968048-4','2966473-0','2967363-1','2968734-9','2968745-4','2967116-7','2967565-0','2969352-7','2968764-0','2969078-1','2966744-5','2965267-7','2968794-2','2967623-1','2969974-6','2968432-3','4073217-7','2966187-0','2968025-5','2968191-0','2968826-4','2966604-0','2967752-1','2966873-5','2965104-2','2965813-6','2965744-0','3216133-6','2966104-8','2968966-0','2967943-5','4072993-1','2965912-4','2969246-6','2966307-5','2967374-7','2969711-5','2967722-0','2968382-3','2965442-4','2969502-3','2969794-8','2968886-8','4072986-9','2965168-9','2965405-0','3232843-5','2969341-1','2969932-0','2965495-5','2965702-4','2965725-3','2969845-6','4073063-8','2967786-6','2968462-5','2965095-0','2969585-6','2969833-2','2969136-2','2965622-2','2965801-2','2965207-3','2965682-6','2966912-0','2967855-2','2967349-6','2969166-4','4073254-1','4073125-1','4073015-8','2966054-8','565328-2','2965553-6','2965362-2','2965541-2','2968147-2','2969863-4','2967715-7','2940347-2','2969944-4','4073045-0')
  29.  
  30. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  31. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 8 -- Perito Criminal 2ª Classe
  32. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  33. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2965088-7','3232645-9','2965431-9','2965325-8','2969555-4','2965281-2','2965350-9','2966954-5','2968308-4','3232806-0','2968421-8','2969573-2','2969704-2','2969672-0','2969985-1','2965348-7','2965306-1','2965385-1','2965732-6','2965594-3','2965652-4','2965571-4','2966024-6','2965905-1','2965633-8','2965237-5','2965461-0','4073056-5','2969764-6','4073026-3','4072974-5','2969308-0','2965244-8','2968715-2','4073137-5','2965854-3','2965214-6','2965065-8','2965603-6','2965884-5','4073236-3','2969902-9','2965675-3','2967443-3','4073206-1','2969815-4','2969914-2','3232657-2','2965564-1','4073033-6','2965663-0','2965774-1','2965714-8','2966065-3','2965896-9','2968188-0','4073266-5','2967188-4','2966157-9','2966134-0','2966088-2','4130554-0','2969635-6','2965076-3','2965256-1','2965523-4','2966017-3','566042-4','2968672-5','2969783-2','2967973-7','2969272-5','2969665-8','3566475-4','2966675-9','2966802-6','2969154-0','2967314-3','2969967-3','2965873-0','4130478-0','4073114-6','2968013-1','2965645-1','4249482-6','2965484-0','565121-2','3216083-6','4355144-0','2965392-4','2967473-5','564739-8','2965785-7','2967913-3','4073167-7','2965534-0','2965792-0','4073197-9','2969886-3','3232818-4','2968844-2','4379355-0','3232862-1','4130303-2','4379550-1','4379482-3','4178566-5','4379577-3','4379483-1','3568453-4','3795183-1','4333951-4','4326288-0','4379475-0','4379624-9','4379599-4','4379396-7','4379615-0','4379344-4','4379368-1','4379073-9','4203548-1','4379385-1','4379393-2','4379397-5','4379364-9','4379407-6','4379606-0','4330244-0','4379471-8','4379477-7','4379470-0','4379467-0','4379392-4','4379522-6','4379371-1','4403192-0','4403211-0','4403195-5','4403183-1')
  34.  
  35. --AND (FREF.EVEN_ID_EVENTO IN (1,5,27,28) -- Posse, Enquadramento, Admissão ou Nomeação
  36. --AND CLFU.CLFU_ID_CLASSE_FUNCNL = 9 -- Perito Criminal 3ª Classe
  37. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  38. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('561721-9','4209074-1','4329482-0','4379403-3','4379459-9','4335946-9','4379362-2','4207459-2','4379366-5','4379379-7','4203528-7','4379498-0','4379507-2','4379516-1','4379544-7','4379487-4','4379504-8','4379512-9','4379529-3','4379535-8','634287-6','4379574-9','559345-0','4379593-5','4379603-6','4379610-9','4379549-8','4373034-5','4403190-4','4403206-4','5035472-8','5035493-0','5035511-2','3710842-5','5035499-0','3360639-0','5035387-0','4432289-5','5035464-7','5035515-5','5035517-1','4434625-5','5035439-6','5035450-7','4377704-0','5035529-5','5035509-0','4177429-9','5035390-0','5035452-3','4303598-1','5035386-1','5035498-1','4374562-8','5035392-6','5035504-0','4249427-3','5035442-6','5020929-9','5035522-8','5035524-4','5035379-9','5035471-0','5035523-6','5035510-4','5035535-0','5035478-7','5035443-4','5035502-3','5035449-3','5035505-8','5000768-8','4347908-1','5035475-2','5035533-3','5035483-3','5035384-5','5035518-0','5035444-2','5035385-3','5035468-0','5035486-8','4389930-7','5035454-0','5035378-0','5035395-0','5035485-0','5035530-9','5035399-3','5035534-1','5035512-0','5035481-7','5035514-7','1759026-4','5035394-2','5035396-9','5035494-9','5035487-6','5035388-8','5035376-4','5035506-6','5035380-2','5035458-2','5035460-4','5035462-0','5035476-0','5035400-0','5035382-9','5035527-9','5035401-9','5035473-6','5035528-7','5035398-5','407-3','5035525-2','5035496-5','5035377-2','5035389-6','5035391-8','5035397-7','5035532-5','5035393-4','4360353-0','5021538-8','5037615-2','5037555-5','5037557-1','5007938-7','5037569-5','5037547-4','5037549-0','5037593-8','5037542-3','4367506-9','5037556-3','5037577-6','5037536-9','5037614-4','5037600-4','567201-5','4207909-8','5037612-8','5037552-0','5037565-2','5023461-7','5037574-1','5037575-0','4255385-7','4418328-3','5037598-9','5037581-4','5037604-7','5037597-0','5037583-0','4348601-0','5037563-6','5037570-9','4357323-1','5037559-8','4370700-9','5021182-0','5037591-1','5037596-2','5037592-0','5037582-2','5037550-4','5037539-3','4248411-1','5037548-2','5037537-7','5037554-7','5037562-8','5037560-1','5037605-5','5037605-5','5037584-9','4456849-5','5037588-1','5037607-1','5037571-7','5037580-6','5037613-6','5037579-2','5037578-4','5037545-8','5037546-6','5037589-0','5037558-0','5037576-8','5037594-6','5037585-7','5037599-7','5037540-7','5037561-0','5037541-5','5037590-3','5037611-0','5037553-9','5037595-4')
  39.  
  40. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  41. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (14) -- Técnico Policial de Necropsia 1ª Classe
  42. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  43. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('291880-4','296754-2','2920802-5','293573-2','300205-5','2918754-0','2920892-0','292801-6','2928244-6','2998294-4','2992864-8','2997874-2','299732-1','4118173-5','2997867-0','299964-2','292205-5','299748-5','292034-4','292098-4','292220-4','291887-6','2920194-2','2969419-1','2921036-4','2922234-6','2920286-8','296948-1','292839-2','292827-4','2921973-6','292021-5','2920615-4','292090-1','2923573-1','2990341-6','292106-6','2921406-8','299859-6','2922066-1','2969925-8','2921874-8','4251364-2','2921298-7','4251029-5','4251056-2','2921195-6','2921616-8','2969955-0','4251359-6','2920774-6','2990433-1','2990474-9','2920226-4','4251043-0','4250990-4','4251022-8','4252976-0','4251361-8','4251032-5','3088167-6')
  44.  
  45. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  46. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (15) -- Técnico Policial de Necropsia 2ª Classe
  47. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  48. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('4176600-8','4251008-2','4251053-8','4200606-6','4251072-4','4251015-5','4251012-0','4251030-9','4251013-9','4251034-1','4251035-0','4251047-3','4251363-4','4251067-8','4152917-0','4250993-9','4251010-4','4251003-1','4251345-6','4250991-2','4250998-0','4251337-5','4250996-3','4251338-3','4251016-3','4250992-0','4251335-9','2082881-0','4251039-2','4251049-0','4251353-7','4251048-1','4251340-5','4251071-6','4251031-7','4183141-1','4251052-0','4251000-7','4251057-0','4251063-5','4251066-0','4251062-7','4251026-0','4251005-8','4385730-2','3720966-3','4354277-8','3367175-3','4385477-0','4342064-8','4385442-7','4385460-5','4385339-0','4385287-4','4385449-4','4251070-8','4385267-0','4385376-5','4273433-9','4385316-1','4385452-4','4385741-8','4385358-7','4385468-0','4385425-7','4385357-9','4385232-7','4385250-5','4385295-5','4385455-9','4385369-2','4385300-5','4385404-4','4385323-4','4385457-5','4385259-9','4385478-8')
  49.  
  50. --AND (FREF.EVEN_ID_EVENTO IN (1,5,27,28) -- Posse, Enquadramento, Admissão ou Nomeação
  51. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (16) -- Técnico Policial de Necropsia 3ª Classe
  52. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  53. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('547274-1','4385375-7','4359720-3','4385294-7','4385413-3','4385438-9','4385480-0','4385419-2','4385697-7','4385335-8','4385353-6','4385446-0')
  54.  
  55. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  56. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (27,28) -- Oficial de Cartório Policial 1ª Classe (Comissário de Polícia)
  57. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  58. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2918494-0','2973268-9','2991974-6','2943652-4','2970964-4','2992247-0','2971336-6','2979137-5','2953147-0','2925328-4','2930334-6','2996024-0','541977-8','2939886-0','2924334-3','2979644-0','2961277-2','2987614-1','2923536-7','2914257-1','2955823-9','2961334-5','2982874-0','2999856-5','2936378-0','2988686-4','2952966-2','2970064-7','2914517-1','2934495-6','2949662-4','2985853-4','2993057-0','2968704-7','2953893-9','2960944-5','2992915-6','2937406-5','2925853-7','2993494-0','2996344-3','2949015-4','2914683-6','2914436-1','3241628-8','2915025-6','2943134-4','2917288-8','2945529-4','2917217-9','2946304-1','2957702-0','2945036-5','2984864-4','2946228-2','2924894-9','3001444-1','2968874-4','2940731-1','2975844-0','2977235-4','2940167-4','2919922-0','2960228-9','542359-7','2984445-2','2954521-8','2924631-8','3002497-8','2949823-6','2973793-1','2924426-9','2924456-0','2913385-8','2916357-9','2958187-7','2935831-0','2940285-9','2955742-9','2952642-6','2918056-2','2912615-0','2952821-6','2947661-5','2979250-9','2963439-3','2976525-0','2933266-4','2923845-5','2927621-7','2950194-6','2946665-2','2943641-9','2982025-1','2964614-6','2926964-4','2976803-9','2996454-7','2925086-2','2941842-9','2938794-9','2925033-1','2951954-3','2923288-0','2977521-3','2974204-8','2973164-0','2926045-0','2943942-6','2980500-7','2954783-0','2912458-1','2916025-1','2948217-8','2993395-1','2956107-8','2941145-9','2964594-8','2916288-2','2995504-1','2957651-2','2918632-3','2983856-8','2915573-8','2944307-5','2944165-0','2982013-8','2995194-1','2995785-0','3001734-3','2956266-0','2972207-1','1937147-0','2970922-9','3000554-0','2985098-3','2970292-5','2926137-6','2950024-9','2961044-3','2957693-8','2939276-4','2960794-9','2931643-0','2924914-7','2942732-0','2986144-6','2930661-2','2961097-4','2979107-3','2960562-8','2985685-0','2975913-7','2927773-6','2938425-7','2937314-0','2983341-8','2925933-9','2933324-5','3241315-7','2963662-0','2938833-3','2928965-3','2934651-7','2922154-4','2983753-7','2914466-3','2939288-8','2964281-7','2914561-9','2964416-0','2936238-5','2935792-6','2961056-7','2992613-0','2914591-0','3000595-7','2955963-4','2945695-9','3001768-8','2917712-0','2968543-5','2988343-1','2973924-1','3236684-1','2926724-2','2953474-7','2978056-0','2946276-2','2976371-1','2921821-7','2987108-5','2972134-2','2925507-4','2978956-7','2964207-8','2946044-1','2955289-3','2980047-1','2930723-6','2915814-1','2917327-2','2925986-0','2964361-9','2945925-7','2987423-8','2945635-5','2982096-0','2932701-6','3245800-2','2917903-3','2998161-1','2958744-1','2916184-3','2945672-0','2960124-0','2932975-2','2994614-0','2977261-3','2961643-3','2984804-0','2935744-6','2923962-1','2956453-0','2942318-0','2976612-5','2958946-0','2945665-7','2915559-2','2935583-4','2947044-7','2953665-0','2950751-0','2933773-9','2950813-4','3236636-1','2950935-1','2951379-0','2954074-7','2941416-4','2975531-0','2985261-7','2927324-2','2913924-4','2941237-4','2989293-7','2931185-3','2932915-9','2946136-7','2997047-4','2988564-7','2985804-6','3236661-2','2912306-2','2932662-1','2919305-2','2921436-0','2994987-4','2984956-0','2989763-7','2923695-9','2952902-6','2995755-9','3241246-0','2915195-3','2938188-6','2984666-8','3245835-5','2913595-8','2993743-4','3001135-3','2963796-1','2924852-3','3241216-9','3241635-0','2943035-6','3241485-4','3003093-5','2915962-8','2995281-6','2999205-2','2995035-0','2936286-5','2944745-3','2933305-9','2930414-8','2996171-8','2950054-0','2955045-9','2928983-1','2974492-0','2911681-3','2959855-9','2982191-6','2972785-5','2997091-1','2939290-0','542939-0','3003498-1','2976272-3','2996512-8','2960463-0','2938591-1','2945591-0','2977502-7','2914275-0','2949784-1','2959622-0','2944116-1','2977735-6','2975271-0','2973645-5','2964842-4','2976601-0','2927366-8','2976711-3','2981432-4','2994824-0','2924067-0','2928610-7','2959215-1','2972256-0','3211345-5','2997623-5','2915368-9','2977705-4','2913447-1','2923944-3','2988249-4','2956632-0','2975985-4','2932952-3','2950116-4','2976419-0','2956614-2','2948533-9','2946067-0','2999985-5','2985206-4','2952393-1','2952392-1')
  59.  
  60. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  61. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (29) -- Oficial de Cartório Policial 2ª Classe
  62. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  63. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('3003003-0','3236578-0','3002486-2','2981418-9','2927812-0','2984463-0','2947148-6','2938437-0','2934458-1','2931067-9','2987331-2','2996091-6','2917986-6','2983886-0','2947864-2','2986471-2','2970317-4','2919835-6','2970674-2','3241517-6','2968227-4','2914478-7','1931015-3','2990371-8','2991815-4','2970335-2','2963510-1','2980942-8','2955834-4','2995824-5','2995274-3','2986034-2','2963842-9','2996763-5','2943751-2','2920793-2','2940540-8','2971317-0','2970655-6','2995744-3','2924735-7','3002757-8','2951084-8','2960573-3','2973954-3','2969235-0','2959282-8','2939932-7','542682-0','2957916-3','2946451-0','2950484-8','2937135-0','2938227-0','2983635-2','2995046-5','2918305-7','2914397-7','2917235-7','2912638-0','2968177-4','2990338-6','2987812-8','2982936-4','2944722-4','3241506-0','2928652-2','2974825-9','2924643-1','2928214-4','2964428-3','2950077-0','2972385-0','2952745-7','2916794-9','4137804-0','2912435-2','2924445-5','2995854-7','2915246-1','2914966-5','2989088-8','2981420-0','2986662-6','2985933-6','2917822-3','2970174-0','2993964-0','2954673-7','2925236-9','2980774-3','2925685-2','2980744-1','2992114-7','2914547-3','2918266-2','2964391-0','2938932-1','1959794-0','2944892-1','2944901-4','2995873-3','2917537-2','2923113-2','2983654-9','2922943-0','2982308-0','2946481-1','2917044-3','2985724-4','2991394-2','2912477-8','2977228-1','2970621-1','2913164-2','2917456-2','2963922-0','2952874-7','2986883-1','2957428-5','2936436-1','2935622-9','2937572-0','2994170-9','2998996-5','2953518-2','2949754-0','2959733-1','2956915-0','2934762-9','2990315-7','2911923-5','2945043-8','2997024-5','2978236-8','2943553-6','2944793-3','2970384-0','2917493-7','2976394-0','2964359-7','3002322-0','564860-2','564840-8','564853-0','564880-7','570987-3','2995905-5','2933167-6','2960783-3','2995965-9','2991452-3','2927285-8','2928843-6','2989215-5','2946014-0','2976044-5','2950972-6','2936226-1','2957317-3','2976863-2','2982955-0','2985342-7','564841-6','2935318-1','2920505-0','2980611-9','2969654-2','2914973-8','2964103-9','2981024-8','2917592-5','2987442-4','2963904-2','2916014-6','2943314-2','2980491-4','2970328-0','2981096-5','2915303-4','2968913-9','2930631-0','564765-7','564768-1','2917551-8','2967664-9','2956218-0','2974307-9','2972732-4','2936896-0','2992784-6','2928491-0','570929-6','2969734-4','2985876-3','4072933-8','2969493-0','2939216-0','2980682-8','2942256-6','2917845-2','2985514-4','2933842-5','2915874-5','2984205-0','2991422-1','564869-6','2970027-2','2980553-8','2999974-0','618953-9','2944047-5','2936459-0','2987384-3','2927801-5','2921745-8','2952913-1','2992192-9','2979575-3','2931277-9','2928127-0','2980176-1','2914123-0','2985137-8','2981054-0','2970236-4','2936843-0','4136205-5','564729-0','564896-3','564921-8','4177303-9','2920751-7','2963876-3','2920627-8','2914425-6','2963964-6','2953074-1','564732-0','564780-0','564883-1','564744-4','564784-3','570975-0','2913355-6','2923882-0','2928378-7','2923654-1','2940045-7','2989793-9','2927552-0','3245791-0','2991136-2','2968814-0','2996774-0','2976955-8','2981105-8','2980756-5','2922025-4','2994361-2','2916467-2','1963923-6','4138378-8','546662-8','564889-0','564857-2','4137811-3','564749-5','564961-7','564773-8','564764-9','564760-6','570901-6','2981282-8','3002617-2','2934681-9','2927145-2','2958267-9','3002974-0','2967924-9','2925894-4','2968085-9','2955137-4','2959293-3','2964016-4','2921775-0','1923811-8','2969327-6','2983985-8','2981077-9','2953196-9','564834-3','555092-0','564833-5','564807-6','564947-1','564797-5','4137796-6','564877-7','564731-2','564866-1','564796-7','564750-9','2996332-0','564752-5','564810-6','564932-3','564964-1','564933-1','563462-8','564762-2','564730-4','564832-7','564935-8','564967-6','564748-7','543629-0','564942-0','4137802-4','570902-4','570911-3','570915-6','4138374-5','570920-2','570921-0','570944-0','570947-4','570958-0','570951-2','4138376-1','4138377-0','3091264-4','570976-8','570988-1','4177299-7','4177296-2','4179690-0','4178852-4','570905-9','564830-0','564963-3')
  64.  
  65. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  66. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (30) -- Oficial de Cartório Policial 3ª Classe
  67. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  68. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('555114-5','555145-5','564924-2','564794-0','564882-3','564972-2','3079493-5','564927-7','4137797-4','564767-3','564941-2','564875-0','564758-4','564923-4','4137803-2','564820-3','564954-4','564804-1','4137809-1','564881-5','4137812-1','564952-8','564772-0','564787-8','564930-7','564734-7','564798-3','4137807-5','564852-1','564814-9','564899-8','564792-4','564783-5','564800-9','564793-2','570927-0','564829-7','564836-0','564736-3','570932-6','1980966-2','570919-9','570918-0','570916-4','570908-3','570909-1','570914-8','570942-3','570931-8','570924-5','570935-0','4138372-9','570937-7','570928-8','570922-9','570940-7','570923-7','570953-9','570952-0','570956-3','570949-0','570959-8','570945-8','570960-1','570948-2','570964-4','570967-9','570971-7','570930-0','570977-6','570982-2','3004296-8','570983-0','4178847-8','1963571-0','590417-0','1981863-7','2491934-9','564256-6','4177291-1','4177300-4','4178853-2','4177302-0','4178848-6','4177297-0','4177289-0','4138375-3','2973187-9','4177305-5','4177290-3','4385721-3','4385770-1','4403140-8','4208056-8','4365171-2','4364974-2','2258144-8','2436486-0','4385833-3','4147384-1','4219185-8','4269894-4','4269855-3','4269727-1','4269910-0','4318260-7','4318187-2','4324000-3','4336763-1','4385731-0','4337694-0','4385763-9','4385781-7','4385714-0','4368773-3','4385684-5','4385875-9','4385778-7','4385754-0','4385700-0','4385690-0','4385785-0','4385705-1','4385826-0','4385749-3','4385703-5','4385738-8','4385832-5','4385823-6','4385683-7','4385825-2','4385670-5','4385767-1','4385916-0','4385780-9','4385671-3','4385724-8','4385818-0','4385775-2','4385858-9','4389222-1','4385863-5','4385834-1','4385743-4','4385799-0','4385699-3','4385873-2','4386806-1','4385847-3','4385772-8','4385851-1','4385735-3','1161627-0','4385807-4','4385854-6','4385824-4','4385801-5','4385713-2','4385788-4','4385871-6','1067815-8','4385658-6','4364780-4','4385773-6','4385706-0','4385733-7','4385722-1','4390521-8','4385759-0','4364877-0','4385852-0','4385814-7','4385655-1','4385805-8','4364947-5','4385791-4','4385656-0','4385787-6','4385762-0','4385654-3','4385704-3','4385779-5','4385669-1','4385864-3','4385692-6','4385865-1','4385676-4','4385828-7','4385846-5','4385702-7','4385845-7','2361403-0','4385747-7','4385796-5','4385718-3','4385769-8','4385760-4','4385756-6','4354691-9','4364881-9','4392596-0','4385797-3','4385868-6','4385782-5','4385876-7','4385848-1','4385802-3','4364964-5','4385810-4','4269740-9','4385750-7','4385674-8','4385798-1','4385707-8','4385804-0','4385727-2','4385664-0','4385838-4','4385867-8','4385745-0','4243104-2','4263548-9','4385740-0','4385822-8','4196256-7','4385736-1','4385869-4','4385829-5','4385659-4','4385708-6','4385857-0','4385742-6','4385866-0','4385685-3','4385861-9','4386801-0','4385870-8','2300304-9','4385812-0','4385698-5','4385850-3','4385737-0','4268898-1','4385686-1','4385874-0','4385715-9','4385819-8','4385795-7','4385777-9','4385849-0','4385673-0','4385663-2','4385837-6','4385813-9','4385751-5','4385855-4','4385694-2','4385665-9','4385709-4','4385748-5','4385661-6','4385792-2','4385729-9','4385794-9','4385817-1','4385835-0','4385811-2','4385660-8','4385757-4','4385766-3','4385789-2','4385693-4','4385764-7','4385862-7','4385839-2','4385680-2','4385719-1','4385783-3')
  69.  
  70. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  71. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (31) -- Oficial de Cartório Policial 4ª Classe
  72. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  73. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('4137808-3','564868-8','564781-9','570934-2','4385723-0','4386812-6','4385695-0','4385809-0','4385758-2','4385752-3','4385915-1','4364907-6','4385831-7','4385808-2','4385711-6','2553054-2','4269832-4','4371542-7','4403138-6','4403148-3','4403197-1','4403409-1','4403174-2','4403139-4','4335966-3','4403184-0','4403150-5','4403204-8','4392662-2','4403147-5','4403133-5','4403127-0','5000716-5','4403158-0','4403165-3','4403130-0','4385827-9','4403170-0','4418361-5','4430025-5','4269770-0')
  74.  
  75. AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  76. AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (32) -- Oficial de Cartório Policial 5ª Classe
  77. AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  78. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('4385734-5','4359256-2','4345787-8')
  79.  
  80. --AND (FREF.EVEN_ID_EVENTO IN (1,5,27,28) -- Posse, Enquadramento, Admissão ou Nomeação
  81. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (33) -- Oficial de Cartório Policial 6ª Classe
  82. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  83. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('5077038-1','5077040-3','5077041-1','5077045-4','5077047-0','5026409-5','4420449-3','4416825-0','5077057-8','5077037-3','4268233-9','5077039-0','5077046-2','5077052-7','5077056-0','5077992-3','5077044-6','4423028-1','5013863-4','5077054-3','5077060-8','5077062-4','5077065-9','5077067-5','5077049-7','5077053-5','5077055-1','5077079-9','5077095-0','5077092-6','5029470-9','5077096-9','5077101-9','5077064-0','5077068-3','5077071-3','5077073-0','5077059-4','5077061-6','5077063-2','5077066-7','5077069-1','5077070-5','5077072-1','5077074-8','5077078-0','5077082-9','5077087-0','4333130-0','5077076-4','5077086-1','5077097-7','614322-9','5077110-8','5077113-2','5077075-6','5077077-2','5077080-2','5077083-7','5077085-3','5077089-6','5077090-0','7077094-2','5077098-5','5077099-3','5077100-0','5009666-4','5077108-6','5013785-9','5077112-4','5077103-5','5077105-1','5077109-4','5077114-0','5077115-9','5077116-7','5077119-1','5077117-5','5077118-3','5014145-7','5077104-3','5077107-8','5077222-8','5077127-2','5077130-2','5077133-7','5077136-1','5012801-9','4392521-9','5077152-3','5077159-0','5077168-0','5077172-8','5077174-4','4390610-9','5077131-0','5077137-0','5077139-6','4213732-2','5077149-3','5077154-0','5077157-4','5077161-2','5077171-0','5077155-8','5077146-9','5077148-5','5077177-9','5077150-7','5077156-6','5077160-4','5077162-0','5077165-5','5077170-1','5077175-2','5077178-7','5077180-9','5077207-4','5077208-2','5077179-5','4345683-9','4252750-3','5077214-7','5077215-5','5077216-3','5077217-1','5077048-9','5077043-8','5012760-8','4244654-6','5077144-2','5077042-0','5014046-2','5077058-6','5077164-7','5077094-2','5077084-5','5013575-9','2438903-0','5079361-6','5079371-3','5079391-8','5079396-9','5079405-1','4344194-7','5079411-6','4396807-4','5030783-5','5079415-9','5079423-0','5079428-0','5079420-5','5079424-8','5079427-2','5079431-0','5079435-3','5014092-2','5079363-2','5079364-0','4380806-9','5079367-5','5079370-5','4251336-7','5079377-2','5079393-4','5079419-1','5079422-1','5079425-6','5079426-4','5079429-9','5079433-7','5079437-0','5079439-6','5079432-9','5079434-5','5079436-1','5079438-8','4408126-0','5032244-3','5079369-1','5022813-7','5079387-0','5079380-2','5079379-9','5079382-9','5079386-1','5079392-6','5079395-0','4365988-8','4351097-3','5079408-6','5079442-6','5079447-7','4330673-0','5079453-1','5079499-0','4213835-3','5079514-7','595271-9','4342047-8','5079458-2','5079406-0','5079452-3','4456027-3','5079455-8','5079457-4','5079479-5','5079485-0','5079491-4','5079520-1','5079526-0','5079542-2','5079463-9','5079474-4','5079501-5','5079496-5','5079518-0','5079521-0','5079538-4','5079544-9','5079553-8','5079560-0','5013598-8','4321100-3','5079475-2','5026302-1','5079495-7','5079504-0','5079498-1','5079505-8','5079509-0','5025909-1','5079547-3','5079576-7','5079579-1','5079583-0','2587125-0','5079523-6','5079525-2','5079539-2','4266830-1','5079549-0','5079556-2','5079563-5','5079564-3','5079566-0','5079545-7','5079559-7','5079562-7','5079575-9','5079570-8','4396676-4','5079571-6','5079578-3','5079548-1','5079554-6','5079574-0','5079577-5','5079580-5','5079582-1','5012928-7','5079572-4','5008051-2','5079587-2','5079588-0','4416980-9','5079589-9','5079460-4','4336854-9','5079417-5','5013594-5','5079440-0','5079402-7','5079376-4','5079414-0','4371877-9','5012697-0','5081675-6','5081637-3','4269818-9','5079384-5','5079375-6','5025932-6','5081789-2','5081695-0','5081661-6','5081661-6','5025903-2','5081712-4','5081716-7','5081683-7','50814788-4','5081753-1','5081704-3','508170-5','5081713-2','4410460-0','4326702-5','5081709-4','5081708-6','5081715-9','5081718-3','5081723-0','5081725-6','5026367-6','4337911-7','5081727-2','5081657-8','5081680-2','5023433-1','5081698-5','5081703-5','5081729-9','5081730-2','5081731-0','5081733-7','5081744-2','5081746-9','5081750-7','5081752-3','5026262-9','5081770-1','5010585-0','5081773-6','5081616-0','5081619-5','5081625-0','5081631-4','4320095-8','5081776-0','5081797-3','5081792-2','4379988-4','5081781-7','5081784-1','5081790-6','5081795-7','4332609-9','5081801-5','567539-1','5081805-8','5081796-5','5081665-9','4336866-2','4396969-0','5081620-9','5081624-1','5081634-9','4407910-9','4423223-3','3150738-7','5082004-4','5081622-5','5081627-6','5081678-0','5081681-0','5081685-3','5081687-0','5081688-8','5081690-0','5081693-4','5081699-3','5081702-7','5081647-0','5081652-7','5081664-0','5081578-4','4321002-3','5081579-2','5081580-6','5081581-4','5081567-9','5081569-5','5081571-7','5081574-1','5081582-2','5081558-0','5081559-8','5081561-0','5081583-0','5081584-9','5081585-7','5081586-5','5081587-3','5081568-7','5081570-9','5009668-0','5081572-5','5081575-0','5081615-2','5081621-7','5081623-3','5081629-2','5014626-2','5081633-0','507206-0','5081636-5','5081638-1','5081700-0','5081706-0','5081710-8','5011299-6','5081720-5','5081724-8','5081726-4','5081728-6','5081800-7','5009580-3','5081804-0','5081793-0','5081808-2','578080-2','5081691-8','5081663-2','5081669-1','5081732-9','5022433-6','5081557-1','5083507-6','5083442-8','4251036-8','4402317-0','5083548-3','5083441-0','4196239-7','508359-9','5084076-2','5083498-3','5083408-8','5083603-0','2420143-0','5083620-0','5083632-3','5083444-4','5083390-1','5083621-8','5083585-8','5083462-2','4219274-9','5083618-8','5083637-4','5083377-4','4413745-1','5009685-0','5083630-7','5083622-6','5083495-9','5083589-0','4343135-6','4256859-5','5030781-9','5083633-1','5032188-9','4248695-5','5083382-0','594071-0','5083643-9','5083385-5','4428505-1','5083642-0','5083378-2','5017742-7','5083628-5','5083570-0','4269208-3','4336962-6','5084382-6','5083631-5','5083460-6','5083590-4','5083603-0','4341152-5','4402317-0','4411750-7','5028718-4','5083488-6','5083609-9','5083607-2','5083583-1','2420143-0','5083387-1','5083405-3','5083422-3','614372-5','5083383-9','5083435-5','5083467-3','4219037-1','5083468-1','4196237-0','4196237-0','5083640-4','5031586-2','5083397-9','5083587-4','5009895-0','5083489-4','5033954-0','5026266-1','4241993-0','5083580-7','5083475-4','5083578-5','5083594-7','5084075-4','5083635-8','4342100-8','5083608-0','5083400-2','5083399-5','5084076-2','4211459-4','5083388-0','5083645-5','5083579-3','5028504-1','5083436-3','5083584-0','5083497-5','5083403-7','5083389-8','5083577-7','5083471-1','5075899-3','5083612-9','5083439-8','5083598-0','50873454-1','5083445-2','4387696-0','4329881-8','5084380-0','4186931-1','4280609-7','5083416-9','4269686-0','5026445-1','5083536-0','5083391-0','5083646-3','5083423-1','5083636-6','5083448-7','5083431-2','5083639-0','4349593-1','4349593-1','5083410-0','5083430-4','5083602-1','4336791-7','5009582-0','5018831-3','5083469-0','5083402-9','5083465-7','5029950-6','4417160-9','5083440-1','5083464-9','5009357-6','4371087-5','5083381-2','5014044-2','4259776-5','4418144-2','5083463-0','5083582-3','5083455-0','5083394-4','4216492-3','5083470-3','5083634-0','4419750-0','5083620-0','5083614-5','5028953-5','5083477-0','4424362-6','5083544-0','5020992-2','5083386-3','5083616-1','5083596-3','4394519-8','4410262-3','5083600-5','5083491-6','5083704-4','4454375-1','5083482-7','5083492-4','5029778-3','5083626-9','5027418-0','5083380-4','5083605-6','4425820-8','5012615-6','5083438-0','5085828-9','5086805-5')
  84.  
  85. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  86. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (22) -- Inspetor de Polícia 2ª Classe
  87. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  88. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2953357-0','2939449-0','2941812-7','2922628-7','2971361-7','2963823-2','2949766-3','2934435-2','2988976-6','2916845-7','2973652-8','2926651-3','2922814-0','2969228-8','2922851-4','2950325-6','2961592-5','2953228-0','2956439-5','2946822-1','2960117-7','2947097-8','2956347-0','2984926-8','2982943-7','2979225-8','2973005-8','2927693-4','2943763-6','2996873-9','2960695-0','2944966-9','2992167-8','2952752-0','2932494-7','2973675-7','2937204-6','2948945-8','3002907-4','2945370-4','2995916-0','2961521-6','2971453-2','2983295-0','2963563-2','2948963-6','3002143-0','2976592-7','2959542-8','2996473-3','2994904-1','2975695-2','2956372-0','2976665-6','2936664-0','2927237-8','2982204-1','2971057-0','2925155-9','2939154-7','2964347-3','2943793-8','2977562-0','2940994-2','2956773-4','2954804-7','2964094-6','2932026-7','2967485-9','2985353-2','2985411-3','2996017-7','2993685-3','2975158-6','2942458-5','2936862-6','2953955-2','546372-6','2915425-1','2953044-0','2981775-7','2947742-5','2988127-7','2935516-8','2961661-1','2957812-4','2950505-4','2963602-7','2970934-2','2991118-4','2974542-0','2961371-0','2913466-8','2977284-2','2950215-2','3219105-7','2949027-8','2947875-8','2932098-4','2948045-0','2944782-8','2925438-8','2930914-0','2936641-0','2978494-8','2982165-7','2984067-8','2963952-2','2994145-8','2925185-0','2936187-7','2945683-5','2944158-7','2978586-3','2956510-3','2933317-2','2995813-0','2944123-4','2954834-9','2932563-3','2954426-2','546709-8','2947592-9','2943268-5','2974844-5','2981066-3','2941633-7','2932606-0','2970464-2','2984037-6','2932390-8','2955883-2','2938370-6','2926754-4','2914448-5','2940922-5','2946741-1','2927785-0','2948922-9','2949045-6','2926773-0','2988115-3','2916833-3','2970278-0','2968833-7','2932593-5','2987987-6','2944006-8','2945874-9','2928995-5','2980461-2','2951492-4','2945474-3','2971854-6','3002166-9','2979193-6','2962834-2','2954624-9','2950744-8','2987317-7','2928854-1','2940945-4','2949621-7','2981271-2','2970582-7','2923246-5','2989756-4','2960852-0','2951984-5','2970510-0','2973984-5','2971064-2','2933391-1','2985192-0','2954463-7','2960449-4','2941306-0','2912465-4','2957644-0','2917921-1','2939974-2','2928801-0','2927725-6','3001085-3','2916295-5','2989512-0','2983833-9','2914802-2','2960925-9','2922573-6','2956754-8','2932296-0','2981443-0','2988465-9','2936583-0','3241554-0','2954518-8','2970471-5','2980622-4','2988615-5','2945554-5','2958652-6','2991795-6','2957255-0','2927278-5','2977097-1','2960437-0','2932206-5','2982635-7','2971359-5','2991228-8','2919805-4','2982985-2','2914892-8','3003196-6','2927317-0','2918620-0','2973664-1','2996127-0','2948178-3','2932537-4','2937257-7','2949167-3','2957824-8','2963754-6','2979464-1','2942461-5','2930573-0','2973733-8','2913367-0','2970494-4','2916734-5','2989786-6','2953833-5','2916368-4','2977383-0','2915345-0','2919094-0','2956464-6','2932075-5','1959704-5','2943744-0','2943355-0','2957872-8','2946863-9','2948494-4','2915066-3','2961712-0','2957103-0','2957453-6','2932692-3','2989505-7','2977452-7','2956533-2','2963533-0','2916882-1','2938803-1','2980604-6','2982996-8','2919126-2','2948883-4','2931196-9','2916265-3','2939124-5','2976421-1','2947217-2','3241407-2','2932724-5','2985434-2','2931956-0','2995774-5','2950714-6','2971428-1','2950786-3','2946357-2','2912912-5','2915584-3','2928645-0','2977944-8','2946902-3','2925098-6','2931056-3','3000738-0','2992643-2','2991445-0','2912801-3','2976723-7','2915055-8','2983612-3','2924804-3','2963865-8','2950652-2','2959176-7','2955277-0','2989572-3','2936268-7','2983684-0','553984-6','2976260-0','2921356-8','2930444-0','2956835-8','2925167-2','2984482-7','2950825-8','2947532-5','3232912-1','2919865-8','2930437-7','2918107-0','2932765-2','565216-2','565690-7','565326-6','565064-0','565106-9','565938-8','565929-9','565862-4','565797-0','571025-1','2942663-4','4177466-3','2957442-0','2929005-8','2962643-9','2933731-3','2940515-7','2986533-6','2917277-2','2953493-3','3000374-1','2945543-0','2992662-9','2941034-7','2977205-2','2989134-5','2985273-0','2998117-4','2915437-5','2988251-6','2953974-9','2962521-1','2956842-0','2978625-8','2952036-3','2992284-4','2980763-8','2925174-5','2916177-0','2986098-9','2977804-2','564995-1','565597-8','565074-7','571278-5','2932376-2','2932754-7','2917067-2','2988168-4','2959374-3','565651-6','2927674-8','565823-3','2958762-0','565311-8','4177445-0','2962712-5','2950095-8','556738-6','571341-2','4177485-0','2976258-8','2931944-7','2949075-8','2961452-0','2973583-1','2934732-7','2953585-9','2977118-8','2941198-0','2927354-4','2946783-7','2945382-8','2996413-0','2980634-8','2917673-5','2979317-3','2988576-0','2948975-0','2951158-5','2963655-8','2954056-9','2940674-9','2916783-3','2959065-5','2960106-1','2945006-3','2942088-1','2942873-4','2926075-2','2943084-4','2950337-0','2924963-5','2917783-9','2955521-3','2951855-5','2992273-9','2917864-9','2963015-0','2917562-3','2984007-4','2948098-1','3002212-6','2938492-3','2946518-4','2951609-9','2923327-5','2932784-9','2976635-4','2973694-3','2918574-2','2995714-1','2917445-7','2924143-0','2915036-1','2969364-0','2959054-0','2941133-5','2953573-5','2951066-0','2959763-3','2923334-8','2995896-2','2986625-1','2979582-6','2962003-1','2963075-4','2923932-0','2948521-5','2953205-1','2946562-1','2970004-3','3236606-0','556721-1','565736-9','4137889-0','565946-9','570998-9','571001-4','4138380-0','571357-9','2932185-9','4177482-5','2968006-9','2913406-4','2971416-8','2981363-8','2988281-8','2928504-6','2988237-0','2926713-7','2941527-6','2955033-5','2938135-5','2916375-7','2916741-8','2945913-3','2913489-7','2933761-5','2992625-4','2954574-9','2942610-3','2991205-9','547299-7','2986087-3','2989565-0','2925247-4','2972976-9','2980017-0','3003205-9','2954371-1','2932003-8','2918346-4','2994656-5','2941983-2','2987237-5','2956292-9','2956004-7','3000397-0','2972442-2','2988171-4','2948026-4','2980652-6','2916985-2','2981374-3','2978533-2','2922642-2','2978933-8','3001073-0','2918673-0','2989813-7','2932107-7','564634-0','565080-1','565968-0','565649-4','565161-1','565653-2','565288-0','2002075-9','571116-9','571168-1','4177367-5','4177385-3','2372569-9','1937258-2','2933724-0','2948956-3','2923276-7','2988534-5','2999833-6','2949156-8','2913325-4','2973461-4','2948075-2','2946426-9','2979423-4','2991106-0','2976216-2','3003063-3','2947518-0','2927607-1','2958442-6','2955811-5','2943256-1','2987274-0','3000807-7','2978284-8','2964087-3','2973417-7','2964805-0','2946654-7','2925876-6','2957405-6','3003323-3','3001223-6','2988145-5','2923304-6','2971087-1','2949987-9','2993736-1','2979515-0','2930628-0','2986614-6','2974271-4','2984433-9','2954452-1','2954875-6','2930562-4','2946985-6','2937024-8','2954661-3','2949186-0','2994331-0','2946944-9','2994317-5','2956384-4','2945078-0','2986582-4','2912718-1','2999716-0','2984944-6','2922303-2','2924723-3','2936256-3','2942866-1','2958385-3','2915821-4','2976776-8','2975124-1','2962383-9','2980024-2','2971442-7','2947136-2','2988484-5','2949952-6','2995725-7','2923315-1','2962625-0','2937892-3','2947288-1','2912065-9','2953822-0','2992178-3','2978544-8','2937901-6','2932581-1','2983067-2','2977834-4','2957842-6','2987755-5','2961822-3','2938612-8','2926365-4','2953067-9','2926114-7','2953106-3','2958983-5','2954178-6','2983106-7','556775-0','564206-0','565307-0','565518-8','565586-2','565180-8','565696-6','565448-3','565683-4','565045-3','565645-1','566020-3','571020-0','571047-2','4138415-6','2037715-0','4177537-6','4177502-3','4177353-5','566029-7','4136903-3','571059-6','2951924-1','3001704-1','2994545-3','2992137-6','2957854-0','2926347-6','2983601-8','2979262-2','2973077-5','3002196-0','2930962-0','2987504-8','2989652-5','2912774-2','2950355-8','2987373-8','2944924-3','2926621-1','2988603-1','2950268-3','2994248-9','2932482-3','2948114-7','2917753-7','2933427-6','2979361-0','2995976-4','2950035-4','2941785-6','2986494-1','2957115-4','2925915-0','2918427-4','2949034-0','2939414-7','2960985-2','2932471-8','2948254-2','2971126-6','2932618-4','2957472-2','2917852-5','2952711-2','2969421-3','2988207-9','2985696-5','2923592-8','2988293-1','2929077-5','2954643-5','2994946-7','2977410-1','2939085-0','2936652-6','2926064-7','2993582-2','2988076-9','3003102-8','2987994-9','2947933-9','2964168-3','2978705-0','2961507-0','2973703-6','2992316-6','4193722-8','2984974-8','2993193-2','2983746-4','2997524-7','2951245-0','2932247-2','2947155-9','2975863-7','2961217-9','2960371-4','2945105-1','2943095-0','2954705-9','2983037-0','2978894-3','2947258-0','2926174-0','2977845-0','2947327-6','2964773-8','565751-2','564979-0','565465-3','2484812-3','556780-7','565301-0','565350-9','565302-9','565116-6','565289-8','565356-8','571108-8','571171-1','571202-5','571307-2','571172-0','4177549-0','4137869-5','2948167-8')
  89.  
  90. --AND (FREF.EVEN_ID_EVENTO IN (2,5,33) -- Promoção, Enquadramento, Apostila
  91. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (23) -- Inspetor de Polícia 3ª Classe
  92. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  93. --AND (FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2937517-7','2928813-4','2947074-9','2941057-6','2988104-8','2995983-7','2945124-8','2923387-9','2984410-0','2945985-0','2917894-0','2989595-2','2959157-0','2922665-1','2932742-3','2925864-2','2981381-6','2961258-6','2961705-7','2951634-0','2984631-5','2972792-8','2971686-1','2950664-6','2984044-9','2949126-6','2937287-9','2933278-8','2992068-0','2988065-3','2963453-9','2915536-3','3002315-7','2995693-5','2938204-1','2972362-0','2946734-9','2929035-0','2946437-4','2986361-9','2949087-1','2948335-2','2973634-0','2950721-9','2960493-1','2951227-1','2957865-5','2992217-8','2931295-7','2935472-2','3001112-4','2979471-4','2994686-7','2986114-4','3000646-5','2944984-7','2987193-0','2913535-4','2946493-5','2917518-6','3001025-0','2960520-2','2969695-0','2971541-5','2917548-8','2917056-7','2917014-1','2987552-8','3003475-2','2986876-9','2994193-8','2986895-5','2977044-0','2984795-8','2994663-8','2955494-2','2997307-4','2941244-7','2977026-2','2983562-3','2995843-1','2932114-0','2915833-8','1959886-6','2987545-5','2931864-5','2954475-0','2941405-9','2932507-2','2931700-2','2977422-5','2976352-5','2950392-2','2993904-6','2956391-7','2965023-2','2932415-7','2918254-9','2915184-8','2970975-0','2948144-9','2986674-0','2948383-2','2962993-4','2932514-5','2963552-7','2945085-3','2947265-2','2963045-2','2935571-0','2948519-3','2959256-9','2959694-7','2975752-5','2943348-7','2973146-1','2973199-2','2971094-4','2954205-7','2984783-4','2932685-0','2964713-4','2926975-0','2985986-7','2984986-1','2929104-6','2976764-4','2975722-3','2938985-2','2959351-4','2924765-9','2912762-9','2941644-2','2992533-9','2987453-0','2931493-3','2932643-5','2930955-7','3000837-9','2979441-2','2918003-1','2936017-0','2962853-9','2994805-3','2960451-6','2997535-2','2988035-1','2917003-6','2915234-8','2922653-8','2946852-3','2981814-1','2986156-0','2983997-1','2979552-4','2976308-8','2977463-2','2964034-2','2925376-4','2957785-3','2945996-6','2989802-1','2979434-0','2978521-9','2997089-0','553539-5','2932445-9','2958523-6','2945722-0','2970701-3','2923147-7','2931334-1','2962593-9','3000991-0','2987248-0','2952195-5','2932551-0','2981406-5','2950047-8','2913187-1','2932335-5','2996392-3','2989714-9','2960414-1','2935843-4','2962956-0','2994218-7','2932346-0','2963483-0','2994087-7','2942428-3','2946371-8','2950733-2','2945600-2','2984341-3','2995806-7','2979342-4','2943215-4','2913397-1','2936714-0','2931415-1','2955876-0','2978975-3','1995906-0','565989-2','565546-3','565611-7','565516-1','565456-4','571000-6','565832-2','2926144-9','2944013-0','2954217-0','3241589-3','2949098-7','2944146-3','2926446-4','2931933-1','2942065-2','2961696-4','2936116-8','2960085-5','2984592-0','3001002-0','2988553-1','3002513-3','2986181-0','2987713-0','2913436-6','2924562-1','2957483-8','2945653-3','2996885-2','2935553-2','2999382-2','2946672-5','2961532-1','2985224-2','2993503-2','2964306-6','2914639-9','2976246-4','2946097-2','3002032-8','3002124-3','2952234-0','2941964-6','2922536-1','3001658-4','2988744-5','2988675-9','2979784-5','2916771-0','2968096-4','2926471-5','3001253-8','2986644-8','2924811-6','2979957-0','2932933-7','3003056-0','2983025-7','2941994-8','2992544-4','2918471-1','3002334-3','2915844-3','2972534-8','2914924-0','2986865-3','2957391-2','2974565-9','2972454-6','2981238-0','2923265-1','2950622-0','2970662-9','2938821-0','2964824-6','2948471-5','2947834-0','2947426-4','2916875-9','2947673-9','2913176-6','2912274-0','2979384-0','2955075-0','2985148-3','2914710-7','2979273-8','2989535-9','2915204-6','2991475-2','2961795-2','2977742-9','2922584-1','1920727-1','2927755-8','2948155-4','2987976-0','2918445-2','2939136-9','2961735-9','2977795-0','2964115-2','2961804-5','2933494-2','2950793-6','2993692-6','2978926-5','2963915-8','2983136-9','564633-2','4137817-2','565346-0','565056-9','2983177-6','565081-0','565830-6','565880-2','565836-5','4177409-4','4177139-7','2946962-7','2993945-3','2994064-8','2940982-9','2993987-9','3001013-6','2947956-8','4137819-9','2997683-9','2960481-8','2933377-6','2926945-8','2985765-1','3202104-6','559456-1','4138379-6','546457-9','2956034-9','2959645-9','2943065-8','565584-6','2988633-3','2915996-2','1959893-9','2927663-2','2970994-6','2914855-3','2974268-4','4268832-9','2986552-2','2946875-2','2945711-4','2945704-1','2941495-4','2938257-2','2943802-0','1954094-9','2988318-0','1959775-4','2969753-0','2988182-0','2940358-8','2950774-0','2972541-0','2979144-8','2963766-0','2922246-0','2964145-4','2969601-1','3002304-1','2934607-0','2986453-4','4072921-4','2938584-9','2924673-3','3001032-2','3003346-2','2921314-2','2945734-3','2994923-8','2982886-4','2987522-6','3002246-0','2971115-0','2958472-8','3001757-2','2947026-9','2922973-1','2965115-8','2965279-0','2968375-0','2986823-8','2959774-9','2996104-1','2963494-6','2948408-1','2963975-1','2947205-9','2979503-6','2954894-2','2948574-6','2959885-0','2950367-1','2971552-0','2940975-6','2972214-4','2956582-0','2979015-8','2926167-8','2994225-0','2956522-7','2986126-8','2918975-6','2917113-0','2959208-9','2914572-4','2961463-5','2999746-1','2992586-0','2948125-2','2996484-9','2959392-1','2952481-4','2947334-9','2992372-7','2946573-7','2912751-3','2959226-7','3002357-2','2946037-9','2979409-9','2930654-0','2950378-7','2918986-1','2963057-6','2947277-6','2956784-0','2971145-2','3001105-1','2939196-2','2935923-6','2986137-3','2952418-0','2947304-7','2985735-0','2985712-0','2918963-2','2964186-1','2946704-7','2986724-0','2947247-4','2937344-1','2915356-5','2931376-7','2949144-4','2973721-4','2926087-6','2926915-6','2918185-2','2983407-4','2983147-4','565768-7','565248-0','565148-4','555124-2','565587-0','565310-0','565826-8','565162-0','565720-2','2993602-0','565338-0','565238-3','4137874-1','565493-9','565209-0','2964835-1','4137832-6','565189-1','555161-7','556658-4','565006-2','566047-5','571063-4','571216-5','571206-8','571274-2','571383-8','571404-4','564251-5','4177519-8','4177320-9','4177389-6','2466196-1','4137898-9','555101-3','2932772-5','2940853-9','2941953-0','2953235-3','2954601-0','2971511-3','2978876-5','2980077-3','2942472-0','2987465-3','2917606-9','2964762-2','2979602-4','2948266-6','2981455-3','2985742-2','2946025-5','2979494-3','2988306-7','2915481-2','562899-7','565934-5','565050-0','565042-9','565446-7','4137840-7','565046-1','2915524-0','2972511-9','2971895-3','2956494-8','2933483-7','565613-3','565887-0','565136-0','571126-6','2918415-0','2983154-7','556744-0','4178781-1','2972774-0','2988090-4','2918284-0','2939723-5','2949197-5','2959873-7','2917074-5','2958836-7','2979206-1','2976463-7','2958755-7','2948346-8','2918296-4','4178855-9','2986632-4','2975315-5','2976925-6','2926823-0','2964674-0','2946474-9','2965016-0','2932712-1','2947684-4','2983078-8','2976794-6','2969723-9','2953246-9','2958813-8','2926644-0','2916617-9','2960147-9','2961074-5','2975856-4','2952794-5','2565933-2','2994693-0','2961067-2','2981694-7','2926904-0','2986743-6','2926526-6','2912405-0','2932549-8','2970692-0','2970034-5','2993754-0','2970156-2','2947772-7','2933388-1','3232668-8','2962846-6','3001043-8','2918075-9','3228177-3','2955581-7','2988774-7','3001775-0','2959832-0','2916205-0','2961852-5','2976783-0','4137860-1','2960886-4','3236647-7','2989583-9','2959362-0','2958785-9','2994621-2','2946177-4','2931178-0','2957953-8','2980484-1','4197997-4','2997634-0','1959863-7','4373716-1','3228295-8','3228196-0','3228154-4','3228184-6','2983444-9','2932655-9','2977822-0','4137904-7','3259185-3','2337006-8','554637-0','565769-5','3991018-0','4136846-0','554541-2','554552-8','554530-7','554642-7','565250-2','565988-4','565488-2','555093-9','555144-7','565489-0','2037314-7','556771-8','556757-2','556727-0','556749-1','556759-9','565540-4','2379248-5','556709-2','565424-6','559457-0','565631-1','559782-0','565692-3','565451-3','565193-0','565040-2','565925-6','565008-9','565765-2','565679-6','556736-0','4137820-2','565113-1','2983433-3','565689-3','4137837-7','565316-9','565183-2','565181-6','565325-8','565881-0','565177-8','564983-8','565194-8','4137882-2','565918-3','565980-9','565996-5','565184-0','565463-7','565188-3','565937-0','565069-0','565861-6','565353-3','565187-5','4137827-0','565195-6','565099-2','565319-3','565012-7','565992-2','565321-5','565097-6','565089-5','563508-0','565025-9','565754-7','565413-0','565124-7','565021-6','566030-0','565532-3','565614-1','564999-4','565886-1','565529-3','565345-2','565468-8','565405-0','565071-2','565711-3','565544-7','565165-4','565336-3','565333-9','565659-1','565412-2','565129-8','565547-1','565385-1','565559-5','565850-0','565526-9','4137844-0','565304-5','3962136-7','2376327-2','565092-5','565740-7','565306-1','565633-8','566017-3','565783-0','565509-9','565855-1','565674-5','566024-6','4137845-8','565436-0','565156-5','565014-3','565036-4','565856-0')
  94. --OR FUVI.FUVI_CD_IDENTF_FUNCNL IN ('565119-0','565759-8','4137899-7','565060-7','565866-7','565382-7','565449-1','566023-8','4137880-6','565652-4','565494-7','565141-7','565128-0','565596-0','565718-0','565698-2','565558-7','565031-3','565660-5','565555-2','565226-0','4137901-2','565397-5','565490-4','565848-9','565434-3','565883-7','4137839-3','4137907-1','3584373-0','565956-6','2977815-8','565462-9','564975-7','4137909-8','4136901-7','4073284-3','565055-0','565420-3','4137816-4','2983189-0','565801-2','565812-8','565018-6','565294-4','565243-0','565877-2','565717-2','565903-5','565569-2','565320-7','565839-0','565375-4','565202-2','565208-1','565747-4','565779-2','565966-3','565190-5','565777-6','565841-1','565713-0','564990-0','565229-4','565577-3','565366-5','565821-7','565719-9','565222-7','565954-0','565580-3','565146-8','565590-0','565791-1','564986-2','565618-4','565214-6','565872-1','4137824-5','565591-9','565507-2','565473-4','565749-0','565859-4','565482-3','563514-4','565766-0','4137862-8','565408-4','565271-5','565010-0','4137896-2','565726-1','4267655-0','565805-5','565650-8','565051-8','565158-1','3389964-9','566045-9','570989-0','571016-2','571022-7','571010-3','571006-5','571011-1','571021-9','564471-2','571030-8','571057-0','4138385-0','571371-4','571088-0','571074-0','571061-8','571058-8','2516286-1','571120-7','571106-1','571152-5','571113-4','4138389-3','571090-1','571158-4','571149-5','571133-9','571183-5','571164-9','4138401-6','571189-4','571191-6','4138396-6','571167-3','571194-0','2185824-1','571246-7','571160-6','571240-8','571257-2','571231-9','571243-2','571283-1','571268-8','571292-0','571267-0','571244-0','571320-0','571355-2','571304-8','571332-3','571333-1','4138411-3','571338-2','571352-8','571330-7','571349-8','571376-5','571369-2','571379-0','571387-0','571386-2','571391-9','571313-7','571399-4','4138417-2','571098-7','1994774-7','2370487-0','2199266-5','612113-6','2037466-6','1994484-5','1978964-5','1984292-9','1985884-1','613067-4','1965448-0','2500931-1','613661-3','4177150-8','4177348-9','4177350-0','4177486-8','4177523-6','4177368-3','4177455-8','4177380-2','4177355-1','4177377-2','4178776-5','4177524-4','4177395-0','4178880-0','4177398-5','4177339-0','4177448-5','4177341-1','4177547-3','4177423-0','4177151-6','4177452-3','571036-7','4177374-8','4177358-6','569971-1','4177438-8','4177526-0','4177453-1','4178862-1','4177323-3','571303-0','4177511-2','3150406-0','4177418-3','4177363-2','4177394-2','4177465-5','4177145-1','4178867-2','4179698-5','4177397-7','4177404-3','4177536-8','4178879-6','4177436-1','4177539-2','4177545-7','4177307-1','4177135-4','4177414-0','4177347-0','4322866-6','4177315-2','4177400-0','565378-9','2268884-6','565626-5','565360-6','565780-6','4137858-0','571230-0','571290-4','4177364-0','4177763-8','915941-0','4177517-1','2983419-8','2941755-4','4177338-1','565292-8','565402-5','4138400-8','565693-1','2998147-6','571115-0','565875-6','2983421-0','2983166-0','565610-9','565762-8','565998-1','565269-3','564977-3','565477-7','565032-1','4137913-6','565784-9','565761-0','4137835-0','565594-3','565969-8','565207-3','565337-1','4137870-9','565669-9','565663-0','565970-1','565111-5','565098-4','566039-4','566037-8','565196-4','565723-7','565913-2','564987-0','565126-3','565641-9','4137873-3','565561-7','565079-8','562895-4','565531-5','565460-2','565496-3','565406-8','566026-2','565907-8','565756-3','565442-4','565259-6','4137849-0','570990-3','571018-9','571075-8','571062-6','571060-0','571156-8','571140-1','571136-3','571186-0','571166-5','571250-5','571346-3','571314-5','571362-5','2241507-6','571393-5','571299-8','2447557-2','571406-0','4177319-5','4177493-0','4177371-3','2004865-3','2438296-5','571039-1','4177310-1','4177354-3','2987732-6','571112-6','4136192-0','1985541-9','565426-2','565945-0','556743-2','565657-5','565152-2','565552-8','565957-4','565999-0','565808-0','565638-9','565419-0','565103-4','565466-1','565537-4','565432-7','565374-6','4137900-4','565371-1','565854-3','565722-9','565976-0','2983085-0','4137911-0','565710-5','565803-9','565628-1','565235-9','566013-0','565746-6','565878-0','565205-7','565457-2','565492-0','565967-1','565625-7','4137847-4','565676-1','565986-8','565318-5','565668-0','565932-9','565802-0','565743-1','565787-3','565535-8','565512-9','565011-9','565484-0','4137872-5','565026-7','565085-2','565517-0','565044-5','565891-8','565268-5','565627-3','565352-5','565363-0','566010-6','565450-5','565117-4','565640-0','565219-7','565433-5','565400-9','565341-0','564984-6','565120-4','565885-3','565139-5','4137830-0','565075-5','4177415-9','4137865-2','565601-0','565472-6','564998-6','565218-9','4137853-9','565962-0','565239-1','565790-3','566048-3','4138382-6','571008-1','571084-7','571083-9','571038-3','571121-5','571118-5','571128-2','571129-0','571195-9','571210-6','4138395-8','571159-2','571269-6','571288-2','571259-9','547413-2','571291-2','571344-7','571372-2','564746-0','2248105-2','2474399-2','4177501-5','4177471-0','4177401-9','571239-4','4177509-0','4177467-1','4177379-9','4177433-7','4177360-8','4177532-5','4178861-3','4177500-7','4177137-0','4177369-1','4177458-2','571053-7','4177487-6','571003-0','1979058-9','4195992-2','571385-4','2264415-6','4319140-1','565355-0','565130-1','2937036-1','4137615-3','565606-0','565078-0','565646-0','565990-6','565864-0','565599-4','565685-0','4137891-1','565244-8','565104-2','565770-9','2983191-1','565423-8','565963-9','565738-5','565135-2','565053-4','565236-7','565439-4','565695-8','565007-0','565888-8','565357-6','565312-6','565070-4','565977-9','565421-1','565486-6','565291-0','565297-9','566021-1','565131-0','565910-8','571004-9','571033-2','571219-0','571254-8','571256-4','2203092-1','4177422-1','4177480-9','4177345-4','4177336-5','4195436-0','4178872-9','4179699-3','4177546-5','4177437-0','4177328-4','4178780-3','571405-2','4373062-0','4137815-6','2959104-0','4137883-0','565471-8','564988-9','565505-6','565788-1','565251-0','565495-5','565622-2','565461-0','565122-0','565914-0','565607-9','565629-0','565867-5','565672-9','565210-3','4137903-9','566022-0','565066-6','565699-0','565884-5','565810-1','565160-3','565950-7','565519-6','565217-0','4137826-1','565118-2','565159-0','556664-9','565615-0','565057-7','565644-3','4137821-0','565716-4','565608-7','565846-2','565686-9','565344-4','4137868-7','565687-7','565379-7','565387-8','565617-6','565401-7','4137908-0','565796-2','565016-0','565151-4','4137823-7','565582-0','565383-5','565960-4','565678-8','4137871-7','565279-0','4137884-9','565143-3','565002-0','565648-6','565314-2','565562-5','565157-3','565022-4','565072-0','565417-3','565048-8','4137814-8','565308-8','565828-4','565858-6','565004-6','565592-7','565435-1','565232-4','565642-7','565919-1','565261-8','565795-4','565909-4','565369-0','565348-7','565764-4','565636-2','565273-1','565172-7','566036-0','565700-8','565506-4','566044-0','570997-0','570993-8','565776-8','4138381-8','2426627-2','4138384-2','571056-1','4138383-4','571087-1','571043-0','571080-4','2694156-2','571127-4','571099-5','571107-0','4138392-3','571163-0','571220-3','571176-2','571178-9','571214-9','571200-9','571170-3','4138399-0','571228-9','2003416-4','4138406-7','3490643-6','571261-0','571263-7','571298-0','571281-5','571271-8','571323-4','4138413-0','4138410-5','2951448-7','571363-3','571308-0','571325-0','571345-5','571348-0','571378-1','571322-6','571373-0','571375-7','4138409-1','4138416-4','571408-7','4177417-5','2212052-1','2509035-6','2204871-5','613674-5','4178860-5','615005-5','4177462-0','4177475-2','4177473-6','4177043-9','4177352-7','4177131-1','571077-4','4178869-9','4178782-0','4178784-6','4177386-1','4177495-7','4177507-4','4177535-0','4177504-0','4177331-4','4177419-1','4177479-5','4177463-9','4177138-9','4178874-5','4177470-1','4177351-9','4177457-4','640132-5','4177335-7','4177481-7','4177326-8','4177503-1','571143-6','4177410-8','4177431-0','4138405-9','4177316-0','4177378-0','4177309-8','4180208-0','4179702-7','4180207-1','4177510-4','4178864-8','4177321-7','4178778-1','4178877-0','2203918-0','4181667-6','2359054-8','1988128-2','4270031-0','565300-2','4178777-3','4373438-3','4373006-0','4373190-2','4372991-6','4372939-8','4137892-0','4137877-6','565829-2','566003-3'))
  95.  
  96. --AND (FREF.EVEN_ID_EVENTO IN (2,5) -- Promoção, Enquadramento
  97. --AND CLFU.CLFU_ID_CLASSE_FUNCNL IN (24) -- Inspetor de Polícia 4ª Classe
  98. --AND FREF.FREF_DT_POSSE <= TO_DATE('21/04/2017 23:59:59','DD/MM/YYYY HH24:MI:SS')) -- Validade
  99. --AND FUVI.FUVI_CD_IDENTF_FUNCNL IN ('2994582-8','2916037-5','2933743-7','2956280-5','2940915-2','2986193-4','4137813-0','565915-9','565240-5','565153-0','565009-7','4137848-2','2474933-8','565604-4','4137854-7','4137851-2','565979-5','565391-6','565498-0','565612-5','565037-2','565476-9','565100-0','565231-6','565916-7','566031-9','565814-4','565900-0','565825-0','565192-1','566025-4','565771-7','565533-1','565807-1','565246-4','565684-2','565329-0','565853-5','565361-4','565272-3','4137838-5','565109-3','565908-6','565904-3','565785-7','4137897-0','565944-2','565368-1','565757-1','565576-5','4137861-0','565712-1','565295-2','565225-1','565390-8','565570-6','565256-1','565023-2','565322-3','4137914-4','565873-0','565852-7','565995-7','4137895-4','565396-7','565983-3','565094-1','565154-9','565773-3','565262-6','4137863-6','565573-0','565453-0','565034-8','565038-0','564994-3','565170-0','565203-0','564974-9','565339-8','565985-0','3148692-4','565441-6','4137843-1','565843-8','4137875-0','565258-8','4137855-5','565708-3','565930-2','565061-5','565411-4','565729-6','565739-3','565230-8','565260-0','564993-5','565585-4','565890-0','565082-8','565212-0','4137818-0','565062-3','565266-9','565265-0','565233-2','565198-0','4177393-4','2920268-0','2213213-9','1998601-7','566049-1','566050-5','571110-0','570991-1','570995-4','2475952-0','571019-7','571015-4','571027-8','571023-5','571014-6','571017-0','2946532-0','571037-5','571044-8','571031-6','571032-4','571046-4','571070-7','571029-4','1610053-0','571049-9','571068-5','571064-2','571040-5','571085-5','571073-1','571081-2','571078-2','2312012-6','1987622-0','571100-2','571097-9','571094-4','571105-3','571096-0','4138318-4','571101-0','571151-7','4138394-0','4138393-1','4138390-7','571119-3','571150-9','571091-0','571130-4','571104-5','571134-7','571157-6','571146-0','571124-0','571089-8','571092-8','571117-7','571122-3','571103-7','2000734-5','3397023-8','571181-9','571217-3','571173-8','571161-4','4138398-2','4138397-4','571199-1','571225-4','571190-8','571224-6','571165-7','571207-6','571212-2','571187-8','565191-3','571192-4','571177-0','571209-2','571184-3','571205-0','571179-7','571201-7','571203-3','571188-6','571236-0','2004785-1','571241-6','571229-7','571251-3','4138404-0','571235-1','571247-5','571233-5','571242-4','571280-7','571277-7','571276-9','571282-3','4138407-5','571272-6','571265-3','571287-4','571285-8','571260-2','571266-1','571279-3','571343-9','571318-8','571321-8','571319-6','571361-7','570788-9','571364-1','571306-4','571359-5','571310-2','571367-6','571334-0','571368-4','571337-4','3150844-8','571351-0','571326-9','571360-9','571154-1','571370-6','571382-0','571339-0','571331-5','571380-3','571388-9','571389-7','571394-3','571398-6','571397-8','571403-6','571396-0','571400-1','564946-3','2011041-3','4177134-6','4177130-3','2000062-6','1987721-8','2001132-6','2000617-9','2008363-7','2001705-7','2009304-7','1994843-3','1982452-1','4177405-1','2009937-1','2000605-5','4177497-3','4177406-0','4177313-6','4177464-7','4177494-9','4178783-8','4177332-2','4177357-8','4177528-7','4177372-1','4177324-1','4177499-0','4177325-0','3127534-6','4178875-3','4177534-1','4177460-4','1967631-0','4177548-1','4178856-7','4177132-0','4177434-5','4177444-2','4177396-9','571052-9','4177144-3','4177477-9','4177461-2','4177141-9','571213-0','4177525-2','2010255-0','4177520-1','4177544-9','4177428-0','4177459-0','4178859-1','4177128-1','4178868-0','4178857-5','4177140-0','4177142-7','4177420-5','4177129-0','594761-8','4177527-9','4177498-1','3595833-2','4177387-0','4177491-4','4177407-8','4177308-0','4177529-5','4178871-0','4179697-7','4177312-8','4177376-4','4177366-7','4177538-4','4177399-3','4178858-3','4177521-0','4177333-0','4177454-0','4177322-5','4177530-9','4179692-6','4179678-0','4177541-4','4178779-0','4177435-3','4177469-8','4177391-8','4177381-0','4177343-8','4177531-7','4177449-3','4178870-2','4178882-6','4177516-3','571329-3','4177408-6','4177478-7','4177384-5','4177342-0','571093-6','4179696-9','4177505-8','4177390-0','1978644-1','2473327-0','4180204-7','4184202-2','2520034-8','4177344-6','4216251-3','613105-0','566051-3','571026-0','565049-6','565086-0','571358-7','571390-0','4177421-3','565952-3','565351-7','571270-0','4177330-6','4178881-8','3151943-1','1996444-7','4138403-2','565863-2','2959843-5','4177402-7','556751-3','565063-1','571079-0','565682-6','3904807-1','2983097-4','4372857-0','654653-6','571249-1','2994564-0','571051-0','571069-3','565661-3','565274-0','565522-6','565680-0','565895-0','565733-4','565164-6','566006-8','565789-0','565173-5','2375863-5','565284-7','2983117-2','565833-0','565940-0','565926-4','4137915-2','565440-8','565015-1','565224-3','2037013-0','566046-7','571067-7','571071-5','3926673-7','4138391-5','571131-2','571302-1','571211-4','571221-1','566054-8','571315-3','571347-1','554163-8','4138412-1','1967902-5','2007215-5','1963380-7','1909015-3','3792575-0','4177468-0','2637245-2','4177349-7','4177361-6','4178883-4','4178863-0','4177518-0','4177489-2','4177451-5','4177442-6','4195435-1','4200010-6','4251262-0','4263788-0','4177327-6','2396256-9','2918438-0','4177472-8','565370-3','571142-8','565964-7','4177148-6','4177488-4','4177439-6','4177133-8','4177382-9','571198-3','571232-7','571328-5','565438-6','564985-4','4179700-0','571145-2','565039-9','593355-2','571028-6','4137859-8','555117-0','571353-6','4179701-9','565399-1','565639-7','566018-1','3232781-1','4270038-8','4270036-1','4270040-0','4373216-0','4373014-0','4196178-1','4342954-8','4364837-1','4364969-6','3383379-6','2006523-0','4373012-4','1983544-2','2476388-8','2484145-5','2613843-3','2362581-3','2204857-0','593709-4','564110-1','4177162-1','4147339-6','4196167-6','4261765-0','4252787-2','4196251-6','4196185-4','4196090-4','4269716-6','4269644-5','4269760-3','4269841-3','4269905-3','4208068-1','4318228-3','4373160-0','4320927-0','4320693-0','4320739-1','4322912-3','4196149-8','4330170-3','4253046-6','4372925-8','4256156-6','4336790-9','4336766-6','4196127-7','2356126-2','4269736-0','4269671-2','4270301-8','4373166-0','4372708-5','4373139-2','4372777-8','4372839-1','4372972-0','4372884-7','4272612-3','4372882-0','4364799-5','4280852-9','4372761-1','4372940-1','4183757-6','4373182-1','4373261-5','4373135-0','4333274-9','4372765-4','4373030-2','4372955-0','4373345-0','4372872-3','4372918-5','4373185-6','4372931-2','4372936-3','4373278-0','4373385-9','4373351-4','4373196-1','4257064-6','3023793-9','4373152-0','4373390-5','4373269-0','4372998-3','4373392-1','4372717-4','4373184-8','4373001-9','4373007-8','4321148-8','4338351-3','650436-1','2192458-9','4373273-9','4373275-5','4373017-5','4373285-2','4373293-3','4373296-8','593207-6','4373302-6','4372748-4','4372763-8','4372760-3','4372753-0','4372756-5','4372863-4','4374501-6','4372800-6','640307-7','4372812-0','4334741-0','640566-5','4337868-4','4320689-1','4372842-1','4372847-2','2418737-2','4372860-0','4372870-7','4372873-1','4372876-6','4372879-0','4372880-4','4373168-6','4373257-7','4373259-3','4269863-4','4373264-0','4373213-5','4323945-5','4261912-2','4373224-0','4373231-3','4373235-6','4373238-0','4373395-6','4373384-0','4364805-3','4373386-7','4373387-5','4373388-3','4373013-2','4373389-1','4373397-2','4373412-0','4373409-0','4373418-9','4373413-8','4373421-9','4373431-6','2277165-4','4373435-9','4372997-5','4372697-6','4372711-5','4372740-9','4364783-9','4372762-0','4372770-0','4195850-0','4372771-9','4372774-3','4372781-6','2874934-0','4372787-5','4372790-5','4372824-3','4364779-0','4372832-4','4372846-4','4372849-9','4372851-0','4372855-3','4372859-6','4372862-6','4372937-1','4372864-2','4372816-2','4373382-4','4373218-6','4372739-5','4373032-9','4365016-3','4372964-9','4343728-1','4372738-7','4372821-9','4373198-8','4372975-4','4364987-4','4372988-6','4250244-6','4373245-3','4372954-1','4373383-2','4373148-1','1848772-6','4373379-4','4373364-6','4364966-1','4372910-0','4219373-7','4372710-7','4376235-2','4364924-6','4373029-9','4373047-7','4372712-3','4372959-2','4335920-5','4373357-3','4372963-0','4373155-4','4241709-0','4373026-4','2223885-9','4270258-5','4373144-9','4364776-6','4364959-9','4373031-0','4373141-4','4373146-5','4372874-0','4372723-9','4372887-1','4349941-4','4372806-5','4364772-3','4373178-3','4372915-0','4372868-5','4373024-8','4364874-6','4373194-5','4364991-2','4372881-2','4373157-0','4373070-1','4373132-5','4372732-8','4373131-7','4372914-2','4372941-0','4373134-1','4372978-9','4372886-3','4364914-9','4373380-8','4367355-4','4373175-9','4303638-4','4373150-3','4372799-9','4372888-0','4373123-6','4373281-0','4373174-0','4373353-0','4372916-9','4373120-1','4372793-0','4365006-6','4372744-1','4373272-0','4372981-9','4373041-8','4373038-8','4372994-0','4372817-0','4372809-0','4373381-6','4373073-6','4372810-3','4364830-4','4372795-6','4372706-9','4372987-8','4373233-0','4269868-5','4372769-7','4372934-7','4364892-4','4373348-4','4373212-7','4373440-5','4372883-9','4364833-9','4359722-0','4372805-7','4372968-1','4373015-9','4373256-9','4373018-3','4364872-0','4373171-6','4372885-5','4373247-0','4372929-0','4373137-6','4372767-0','4373359-0','4373189-9','4372992-4','4372811-1','4373151-1','4373020-5','4373143-0','4358466-7','4372728-0','4373181-3','4364975-0','4373197-0','4264862-9','4373199-6','4372986-0','4373205-4','4373214-3','4373209-7','4252709-0','4364814-2','4373100-7','4372899-5','4372924-0','4373094-9','4372943-6','4372957-6','4372969-0','4372974-6','4187582-6','4372982-7','4372917-7','4372927-4','4372933-9','4372950-9','4372958-4','4372962-2','4364876-2','4373365-4','4372989-4','4372993-2','4372996-7','4373005-1','4372995-9','4373021-3','4373023-0','4373022-1','4373375-1','4373067-1','4373076-0','4373107-4','1175607-1','4321471-1','4373159-7','4372696-8','4360307-6','4373371-9','2415075-4','4372741-7','4374476-1','4342083-4','4372724-7','566007-6','4177513-9','4372945-2','4372889-8','4372922-3','4177340-3','4140472-6','4373254-2','5009784-9','4372928-2','4372944-4','2206915-1','4140636-2','4183672-3','4268676-8','4320887-8','4398177-1','4398160-7','4398165-8','4203591-0','4398154-2','4398176-3','4398252-2','4398143-7','4398155-0','640248-8','4320852-5','4359532-4','4398250-6','4398169-0','4388078-9','4398159-3','4398150-0','640261-5','4398152-6','4250399-0','4398174-7','4398258-1','4398144-5','4258877-4','4398153-4','4398156-9','4398151-8','4398146-1','4398149-6','4398170-4','4398173-9','4398634-0','4398145-3','4398275-1','4398147-0','4398148-8','4398163-1','4371887-6','4336931-6')
  100. )
  101. )
  102. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!