<\/p>\n
\r\nSELECT user_name\r\n ,paf2.person_id approver_personid\r\n ,paf2.full_name approver_fullname\r\n ,recipient_role user_name\r\n ,wn.begin_date\r\n ,wn.status\r\n ,wn.subject\r\n ,wn.message_name\r\n FROM per_all_assignments_f paaf\r\n ,per_all_people_f paf1\r\n ,per_jobs pjb\r\n ,per_positions ppo\r\n ,per_all_people_f paf2\r\n ,fnd_user fu\r\n ,wf_notifications wn\r\n WHERE paaf.person_id = paf1.person_id\r\n AND paaf.supervisor_id = paf2.person_id\r\n AND paaf.job_id = pjb.job_id(+)\r\n AND paaf.position_id = ppo.position_id(+)\r\n AND (SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date)\r\n AND (SYSDATE BETWEEN paf1.effective_start_date AND paf1.effective_end_date)\r\n AND (SYSDATE BETWEEN paf2.effective_start_date AND paf2.effective_end_date)\r\n AND fu.employee_id = paf2.person_id\r\n AND wn.recipient_role = fu.user_name\r\n<\/pre>\n<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT user_name ,paf2.person_id approver_personid ,paf2.full_name approver_fullname ,recipient_role user_name ,wn.begin_date ,wn.status ,wn.subject ,wn.message_name FROM per_all_assignments_f paaf ,per_all_people_f paf1 ,per_jobs pjb ,per_positions ppo ,per_all_people_f paf2 ,fnd_user fu… <\/p>\n","protected":false},"author":231,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127,126,110,56,121,138],"tags":[],"class_list":["post-15884","post","type-post","status-publish","format-standard","hentry","category-applications","category-developer-tools","category-estudo-e-pesquisa","category-oracle","category-oracle_ebs_tecnico","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/231"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15884"}],"version-history":[{"count":5,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15884\/revisions"}],"predecessor-version":[{"id":15892,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15884\/revisions\/15892"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}