APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 442: FROM per_all_people_f per

438: RETURN NUMBER IS
439:
440: CURSOR csr_get_dob IS
441: SELECT trunc (date_of_birth)
442: FROM per_all_people_f per
443: ,per_all_assignments_f paf
444: WHERE per.person_id = paf.person_id
445: AND paf.assignment_id = p_assignment_id
446: AND p_effective_date BETWEEN per.effective_start_date

Line 2284: FROM per_all_people_f pap

2280:
2281: g_payroll_action_id := pactid; --14793405
2282:
2283: sqlstr := 'SELECT DISTINCT person_id
2284: FROM per_all_people_f pap
2285: ,pay_payroll_actions ppa
2286: WHERE ppa.payroll_action_id = :payroll_action_id
2287: AND ppa.business_group_id = pap.business_group_id
2288: ORDER BY pap.person_id';

Line 2377: ,per_all_people_f pap

2373: ,paa.person_id
2374: FROM pay_payroll_actions ppa
2375: ,per_org_structure_versions posv
2376: ,per_all_assignments_f paa
2377: ,per_all_people_f pap
2378: WHERE posv.organization_structure_id = c_org_struct_id
2379: AND posv.date_from <= c_end_date
2380: AND nvl (posv.date_to
2381: ,hr_general.end_of_time) >= c_start_date

Line 2880: FROM per_all_people_f pap

2876: ,'N'
2877: ,'9'
2878: ,'0') gender
2879: ,pap.date_of_death date_of_death
2880: FROM per_all_people_f pap
2881: WHERE pap.person_id = c_person_id
2882: AND business_group_id = c_bg_id
2883: AND c_effective_date BETWEEN pap.effective_start_date
2884: AND pap.effective_end_date;

Line 2927: FROM per_all_people_f pap

2923: 'BE_LIV_TOG',1,
2924: 'REG_PART',1,
2925: 'BE_WID_PENS',4,
2926: NULL) ms_code
2927: FROM per_all_people_f pap
2928: WHERE pap.person_id = c_person_id
2929: AND business_group_id = c_bg_id
2930: AND c_effective_date BETWEEN pap.effective_start_date
2931: AND pap.effective_end_date;

Line 2956: FROM per_all_people_f

2952: ,c_end_date IN DATE) IS
2953: SELECT substr(last_name, 1, 200) last_name
2954: ,substr(pre_name_adjunct, 1, 10) prefix
2955: ,substr(replace(replace(per_information1,'.',''),' ',''), 1, 6) init
2956: FROM per_all_people_f
2957: WHERE person_id IN
2958: (
2959: SELECT contact_person_id
2960: FROM per_contact_relationships