APPS.HR_SECURITY_INTERNAL dependencies on PER_PERIODS_OF_SERVICE
Line 2864: from per_periods_of_service p
2860: from per_all_assignments_f asg
2861: where asg.person_id=p_person_id
2862: and ( (asg.assignment_type='E'
2863: and asg.effective_end_date = (select max(p.actual_termination_date) 2864: from per_periods_of_service p 2865: where p.person_id = p_person_id)
2866: ) or
2867: (asg.assignment_type='A'
2868: and asg.effective_end_date = (select max(ap.date_end)