APPS.PAY_GB_UPGRADE_PKG dependencies on PER_ALL_PEOPLE_F

Line 22: from per_all_people_f papf

18: select 'Y'
19: from dual
20: where exists
21: (select null
22: from per_all_people_f papf
23: where papf.person_id = p_person_id
24: and papf.registered_disabled_flag is not null)
25: or
26: exists (select null

Line 28: per_all_people_f papf

24: and papf.registered_disabled_flag is not null)
25: or
26: exists (select null
27: from per_disabilities_f pdf,
28: per_all_people_f papf
29: where pdf.person_id =papf.person_id
30: and pdf.category not in ('Y','N','ND')
31: and papf.person_id = p_person_id);
32: begin

Line 66: from per_all_people_f papf

62: papf.object_version_number,
63: nvl(papf.employee_number,' ') employee_number ,
64: papf.person_id person_id,
65: nvl(papf.full_name,' ') full_name
66: from per_all_people_f papf
67: where papf.person_id = p_person_id
68: and papf.registered_disabled_flag is not null
69: order by papf.person_id,effective_start_date;
70:

Line 102: per_all_people_f papf

98: pdf.effective_start_date effective_start_date,
99: pdf.effective_end_date effective_end_date,
100: pdf.object_version_number object_version_number
101: from per_disabilities_f pdf,
102: per_all_people_f papf
103: where pdf.person_id =papf.person_id
104: and (pdf.category not in ('Y','N','ND'))
105: and papf.person_id = p_person_id
106: order by papf.person_id;

Line 268: update per_all_people_f

264:
265: hr_utility.set_location('Entering ' || l_proc,50);
266: --Correcting the person record, setting Disability field to null
267:
268: update per_all_people_f
269: set registered_disabled_flag = null
270: where person_id = p_person_id
271: and effective_start_date = v_csr_details.effective_start_date;
272: --and object_version_number= v_csr_details.object_version_number