DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on PER_ALL_PEOPLE_F

Line 340: from per_all_people_f p,

336: cursor csr_age_date is
337: -- calculate the element entry start date according to the qualifying age
338: -- condition
339: select add_months(p.date_of_birth, (l_qualifying_age * 12))
340: from per_all_people_f p,
341: per_assignments_f asg
342: where p.person_id = asg.person_id
343: and p.date_of_birth is not null
344: and asg.assignment_id = p_assignment_id

Line 348: from per_all_people_f papf

344: and asg.assignment_id = p_assignment_id
345: -- session_date comparison has been removed, so ensure that
346: -- looking at the recent data.
347: and p.effective_start_date = (select max(papf.effective_start_date)
348: from per_all_people_f papf
349: where papf.person_id = asg.person_id);
350: --
351: begin
352: g_debug := hr_utility.debug_enabled;