DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on PER_ALL_PEOPLE_F

Line 371: from per_all_people_f p,

367: cursor csr_age_date is
368: -- calculate the element entry start date according to the qualifying age
369: -- condition
370: select add_months(p.date_of_birth, (l_qualifying_age * 12))
371: from per_all_people_f p,
372: per_assignments_f asg
373: where p.person_id = asg.person_id
374: and p.date_of_birth is not null
375: and asg.assignment_id = p_assignment_id

Line 379: from per_all_people_f papf

375: and asg.assignment_id = p_assignment_id
376: -- session_date comparison has been removed, so ensure that
377: -- looking at the recent data.
378: and p.effective_start_date = (select max(papf.effective_start_date)
379: from per_all_people_f papf
380: where papf.person_id = asg.person_id);
381: --
382: begin
383: g_debug := hr_utility.debug_enabled;