APPS.HRI_EDW_FCT_RECRUITMENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 76: ,per_assignment_status_types ast

72: SELECT asg.effective_start_date
73: ,asg.change_reason
74: ,DECODE(next_asg.assignment_id, to_number(null), g_success, 1)
75: FROM per_all_assignments_f asg
76: ,per_assignment_status_types ast
77: ,per_all_assignments_f next_asg
78: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
79: AND asg.assignment_id = p_assignment_id
80: AND ast.per_system_status = v_csr_system_status