DBA Data[Home] [Help]

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