APPS.PAY_GB_UPGRADE_PKG dependencies on PER_DISABILITIES_F

Line 27: from per_disabilities_f pdf,

23: where papf.person_id = p_person_id
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);

Line 76: from per_disabilities_f pdf

72: cursor csr_disability_details
73: is
74: select pdf.disability_id,
75: pdf.object_version_number
76: from per_disabilities_f pdf
77: where pdf.person_id = p_person_id
78: order by pdf.effective_start_date desc;
79:
80: cursor csr_disability_det

Line 84: from per_disabilities_f pdf

80: cursor csr_disability_det
81: is
82: select pdf.disability_id,
83: pdf.object_version_number
84: from per_disabilities_f pdf
85: where pdf.person_id = p_person_id
86: order by pdf.effective_start_date desc;
87:
88: --Fetches the disability records recorded with Non-GB specific categories.

Line 101: from per_disabilities_f pdf,

97: nvl(pdf.degree,'') degree,
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

Line 166: insert into per_disabilities_f

162: fetch csr_disability_details into v_disability_id_new,v_object_version_number_new;
163: if csr_disability_details%notfound then
164:
165: hr_utility.set_location('Entering ' || l_proc,30);
166: insert into per_disabilities_f
167: (disability_id
168: ,effective_start_date
169: ,effective_end_date
170: ,person_id

Line 205: insert into per_disabilities_f

201: else
202:
203: -- Creating date track updates against Disability records
204: hr_utility.set_location('Entering ' || l_proc,40);
205: insert into per_disabilities_f
206: (disability_id
207: ,effective_start_date
208: ,effective_end_date
209: ,person_id

Line 239: (select null from per_disabilities_f

235: ,-1
236: ,-1
237: from dual
238: where not exists
239: (select null from per_disabilities_f
240: where effective_start_date = v_csr_details.effective_start_date
241: and effective_end_date = v_csr_details.effective_end_date
242: and person_id = p_person_id)
243: ;

Line 257: update per_disabilities_f

253: fetch csr_disability_details into v_disability_id_new,v_object_version_number_new;
254: if csr_disability_details%found then
255:
256: hr_utility.set_location('Entering ' || l_proc,45);
257: update per_disabilities_f
258: set effective_end_date = v_csr_details.effective_end_date
259: where disability_id = v_disability_id_new
260: and category = v_csr_details.category;
261: end if;

Line 304: update per_disabilities_f

300:
301: --Correcting the disability record, updating category field to 'Yes' against non-GB Categories.
302: hr_utility.set_location('Entering ' || l_proc,70);
303:
304: update per_disabilities_f
305: set category='Y'
306: where effective_start_date = v_dis_det.effective_start_date
307: and disability_id = v_dis_det.disability_id ;
308: