APPS.PAY_IE_PAYE_PKG dependencies on PER_ALL_PEOPLE_F

Line 742: FROM per_all_people_f pap

738: l_func VARCHAR2(14):= 'get_pps_number';
739:
740: Cursor csr_pps_number IS
741: SELECT nvl(pap.national_identifier, 'X')
742: FROM per_all_people_f pap
743: ,per_all_assignments_f paa
744: ,pay_payroll_actions ppa
745: WHERE ppa.payroll_action_id = p_payroll_action_id
746: and paa.assignment_id = p_assignment_id

Line 2092: FROM per_all_people_f per

2088: -- Cursor get_db
2089: --
2090: CURSOR get_dob IS
2091: SELECT date_of_birth,per.last_name,paf.assignment_number
2092: FROM per_all_people_f per
2093: ,per_all_assignments_f paf
2094: WHERE per.person_id = paf.person_id
2095: AND paf.assignment_id = p_assignment_id
2096: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 2157: FROM per_all_people_f per

2153: -- Cursor get_db
2154: --
2155: CURSOR get_dob IS
2156: SELECT date_of_birth,per.last_name,paf.assignment_number
2157: FROM per_all_people_f per
2158: ,per_all_assignments_f paf
2159: WHERE per.person_id = paf.person_id
2160: AND paf.assignment_id = p_assignment_id
2161: AND l_date_paid BETWEEN per.effective_start_date AND per.effective_end_date