APPS.PAY_FI_ARCHIVE_UMFR dependencies on PER_ALL_PEOPLE_F

Line 617: , per_all_people_f pap

613: ,pay_run_results RR
614: ,pay_element_entries_f PEEF
615: ,pay_element_types_f PETF
616: , pay_input_values_f PIV
617: , per_all_people_f pap
618: WHERE ppa.payroll_action_id = p_payroll_action_id
619: AND appa.effective_date BETWEEN l_period_start_date
620: AND l_period_end_date
621: AND as1.person_id BETWEEN p_start_person

Line 685: , per_all_people_f pap

681: ,pay_run_results RR
682: ,pay_element_entries_f PEEF
683: ,pay_element_types_f PETF
684: , pay_input_values_f PIV
685: , per_all_people_f pap
686: WHERE ppa.payroll_action_id = p_payroll_action_id
687: AND appa.effective_date BETWEEN l_period_start_date
688: AND l_period_end_date
689: AND as1.person_id BETWEEN p_start_person

Line 755: , per_all_people_f pap

751: ,pay_run_results RR
752: ,pay_element_entries_f PEEF
753: ,pay_element_types_f PETF
754: , pay_input_values_f PIV
755: , per_all_people_f pap
756: WHERE ppa.payroll_action_id = p_payroll_action_id
757: AND appa.effective_date BETWEEN l_period_start_date
758: AND l_period_end_date
759: AND as1.person_id BETWEEN p_start_person

Line 1270: csr_v_business_group_id per_all_people_f.business_group_id%TYPE,

1266: -- This cursor fetches Trade Union Details
1267:
1268:
1269: CURSOR csr_person_details (
1270: csr_v_business_group_id per_all_people_f.business_group_id%TYPE,
1271: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1272: )
1273: IS
1274: SELECT pap.LAST_NAME || ' ' || pap.FIRST_NAME NAME, pap.national_identifier,

Line 1278: FROM per_all_people_f pap,

1274: SELECT pap.LAST_NAME || ' ' || pap.FIRST_NAME NAME, pap.national_identifier,
1275: paa.assignment_id assignment_id,
1276: pap.per_information18 membership_start_date,
1277: pap.per_information19 membership_end_date
1278: FROM per_all_people_f pap,
1279: per_all_assignments_f paa,
1280: hr_soft_coding_keyflex scl,
1281: pay_assignment_actions pasa
1282: WHERE paa.person_id = pap.person_id