APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_ALL_PEOPLE_F

Line 268: l_per_rec per_all_people_f%rowtype;

264: --
265: -- Fix for Bug 5152193 Starts here
266:
267: l_pds_rec per_periods_of_service%rowtype;
268: l_per_rec per_all_people_f%rowtype;
269: l_orig_hire_warning boolean;
270: l_dob_null_warning boolean;
271: l_name_combination_warning boolean;
272:

Line 278: select * from per_all_people_f

274: select * from per_periods_of_service
275: where period_of_service_id = p_period_of_service_id;
276:
277: cursor csr_get_per_rec(p_person_id number,p_date date) is
278: select * from per_all_people_f
279: where person_id = p_person_id
280: and effective_start_date >= p_date;
281:
282:

Line 550: -- Invoke per_per_upd.upd only to update Date of Death in per_all_people_f ONLY

546: loop
547: fetch csr_get_per_rec into l_per_rec;
548: exit when csr_get_per_rec%NOTFOUND ;
549:
550: -- Invoke per_per_upd.upd only to update Date of Death in per_all_people_f ONLY
551: -- when leaving reason has been set to Deceased and Date of Death has NOT been
552: -- previously set.
553:
554: -- per_per_upd.upd updates the Date of Death to Actual Termination Date(ATD)