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