DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1238: FROM per_assignment_status_types

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