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