APPS.OE_APPROVALS_WF dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 3155: FROM per_assignment_status_types
3151: OR person.current_npw_flag = 'Y'
3152: )
3153: AND asg.assignment_status_type_id NOT IN (
3154: SELECT assignment_status_type_id 3155: FROM per_assignment_status_types 3156: WHERE per_system_status =
3157: 'TERM_ASSIGN')
3158: AND TRUNC (SYSDATE)
3159: BETWEEN asg.effective_start_date