APPS.HRI_OPL_PER_PERSON dependencies on PER_ALL_PEOPLE_F

Line 612: FROM per_all_people_f per

608: ,per.first_name
609: ,per.person_id
610: ,NVL(per.marital_status,'NA_EDW')
611: ,NVL(per.sex,'NA_EDW')
612: FROM per_all_people_f per
613: ,po_agents poa
614: WHERE per.person_id = poa.agent_id(+)
615: AND TRUNC(sysdate) between per.effective_start_date and per.effective_end_date
616: AND NOT EXISTS (SELECT 'x'

Line 724: FROM per_all_people_f per

720: ,per.first_name
721: ,per.person_id
722: ,per.marital_status
723: ,per.sex
724: FROM per_all_people_f per
725: WHERE per.person_id = tbl.per_person_pk
726: AND TRUNC(sysdate)
727: between per.effective_start_date and per.effective_end_date
728: )

Line 731: from per_all_people_f per1

727: between per.effective_start_date and per.effective_end_date
728: )
729: WHERE tbl.per_person_pk in
730: (SELECT per1.person_id
731: from per_all_people_f per1
732: where per1.last_update_date
733: between g_start_date and g_end_date
734: );
735: --

Line 746: FROM per_all_people_f per

742:
743: DELETE
744: FROM hri_cs_per_person_ct tbl
745: WHERE NOT EXISTS (SELECT 'x'
746: FROM per_all_people_f per
747: WHERE per.person_id = tbl.per_person_pk
748: AND TRUNC(sysdate) BETWEEN
749: per.effective_start_date AND per.effective_end_date )
750: and tbl.per_person_pk <> -1;

Line 833: FROM per_all_people_f per,

829: ,per.first_name
830: ,per.person_id
831: ,NVL(per.marital_status,'NA_EDW')
832: ,NVL(per.sex,'NA_EDW')
833: FROM per_all_people_f per,
834: po_agents poa
835: WHERE TRUNC(sysdate) between per.effective_start_date and per.effective_end_date
836: AND per.person_id = poa.agent_id(+);
837: