APPS.OKC_REP_WF_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 620: FROM per_assignment_status_types

616: AND asg.assignment_type IN ( 'E', 'C' )
617: AND ( per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y' )
618: AND asg.assignment_status_type_id NOT IN
619: ( SELECT assignment_status_type_id
620: FROM per_assignment_status_types
621: WHERE per_system_status = 'TERM_ASSIGN' )
622: AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
623: ORDER BY per.last_name )
624: WHERE ROWNUM = 1;