APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PER_PEOPLE_F

Line 114: ' FROM per_people_f p,' ||

110: -- Archive the payroll action level data and EIT defintions.
111: -- sql string to SELECT a range of assignments eligible for archival.
112: -------------------------------------------------------------------------
113: p_sql := ' SELECT distinct p.person_id' ||
114: ' FROM per_people_f p,' ||
115: ' pay_payroll_actions pa' ||
116: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
117: ' AND p.business_group_id = pa.business_group_id' ||
118: ' ORDER BY p.person_id';

Line 626: ,per_people_f PPF

622: IS
623: SELECT PAF.assignment_id
624: ,PPS.actual_termination_date
625: FROM per_assignments_f PAF
626: ,per_people_f PPF
627: ,per_periods_of_service PPS
628: ,pay_population_ranges PPR
629: ,pay_payroll_actions PPA
630: WHERE PAF.person_id = PPF.person_id

Line 684: ,per_people_f PPF

680: IS
681: SELECT PAF.assignment_id
682: ,PPS.actual_termination_date
683: FROM per_assignments_f PAF
684: ,per_people_f PPF
685: ,per_periods_of_service PPS
686: WHERE PAF.person_id = PPF.person_id
687: AND PPF.person_id = PPS.person_id
688: AND PAF.business_group_id = p_business_group_id

Line 964: FROM per_people_f PPF

960: ,DECODE(PADR.address_id,NULL,PADC.town_or_city,PADR.town_or_city) district_code
961: ,DECODE(PADR.address_id,NULL,PADC.address_line1 ,PADR.address_line1) address_line1
962: ,DECODE(PADR.address_id,NULL,PADC.address_line2 ,PADR.address_line2) address_line2
963: ,DECODE(PADR.address_id,NULL,PADC.address_line3 ,PADR.address_line3) address_line3
964: FROM per_people_f PPF
965: , per_assignments_f PAF
966: , per_periods_of_service PPS
967: , per_addresses PADR
968: , per_addresses PADC