APPS.HR_UTIL_MISC_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 513: FROM per_assignments_f2 paf, per_assignment_status_types past

509:
510:
511: cursor fetch_asg (l_person_id NUMBER, l_effective_date DATE) is
512: SELECT 'T'
513: FROM per_assignments_f2 paf, per_assignment_status_types past
514: WHERE paf.person_id = l_person_id
515: AND l_effective_date between paf.effective_start_date and paf.effective_end_date
516: AND paf.primary_flag = 'Y'
517: AND paf.assignment_type IN ('E', 'C')