DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1239: FROM per_assignment_status_types

1235: or person.current_npw_flag = 'Y' )
1236: and asg.assignment_status_type_id not in
1237: (
1238: SELECT assignment_status_type_id
1239: FROM per_assignment_status_types
1240: WHERE per_system_status = 'TERM_ASSIGN'
1241: )
1242: and trunc(sysdate) between asg.effective_start_date
1243: and asg.effective_end_date