APPS.HR_SECURITY_INTERNAL dependencies on PER_APPLICATIONS

Line 2829: from per_applications ap

2825: where p.person_id = p_person_id)
2826: ) or
2827: (asg.assignment_type='A'
2828: and asg.effective_end_date = (select max(ap.date_end)
2829: from per_applications ap
2830: where ap.person_id = p_person_id)
2831: ) );
2832: --
2833: l_person_id per_assignments_f.person_id%TYPE;