APPS.AR_AME_CMWF_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 224: FROM per_assignment_status_types

220: AND per_all_assignments_f.assignment_type in ('E','C')
221: AND per_all_assignments_f.assignment_status_type_id
222: NOT IN
223: (SELECT assignment_status_type_id
224: FROM per_assignment_status_types
225: WHERE per_system_status = 'TERM_ASSIGN');
226:
227: BEGIN
228: