APPS.HR_UTIL_MISC_SS dependencies on PER_ASSIGNMENTS_F2

Line 521: FROM per_assignments_f2 paf, per_assignment_status_types past

517:
518:
519: cursor fetch_asg (l_person_id NUMBER, l_effective_date DATE) is
520: SELECT 'T'
521: FROM per_assignments_f2 paf, per_assignment_status_types past
522: WHERE paf.person_id = l_person_id
523: AND l_effective_date between paf.effective_start_date and paf.effective_end_date
524: AND paf.primary_flag = 'Y'
525: AND paf.assignment_type IN ('E', 'C')