APPS.AR_AME_CMWF_API dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 226: FROM per_assignment_status_types
222: AND per_all_assignments_f.assignment_type in ('E','C')
223: AND per_all_assignments_f.assignment_status_type_id
224: NOT IN
225: (SELECT assignment_status_type_id 226: FROM per_assignment_status_types 227: WHERE per_system_status = 'TERM_ASSIGN');
228:
229: BEGIN
230: