APPS.AME_ABSOLUTE_JOB_LEVEL_HANDLER dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 57: from per_assignment_status_types

53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in
56: (select assignment_status_type_id
57: from per_assignment_status_types
58: where per_system_status = 'TERM_ASSIGN') and
59: trunc(sysdate) between
60: per_all_assignments_f.effective_start_date and
61: per_all_assignments_f.effective_end_date;