APPS.AME_SUPERVISORY_HANDLER dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 46: from per_assignment_status_types

42: per_all_assignments_f.primary_flag = 'Y' and
43: per_all_assignments_f.assignment_type in ('E','C') and
44: per_all_assignments_f.assignment_status_type_id not in
45: (select assignment_status_type_id
46: from per_assignment_status_types
47: where per_system_status = 'TERM_ASSIGN') and
48: trunc(sysdate) between
49: per_all_assignments_f.effective_start_date and
50: per_all_assignments_f.effective_end_date;