DBA Data[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 2824: from per_periods_of_service p

2820: from per_all_assignments_f asg
2821: where asg.person_id=p_person_id
2822: and ( (asg.assignment_type='E'
2823: and asg.effective_end_date = (select max(p.actual_termination_date)
2824: from per_periods_of_service p
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)