APPS.HRI_OPL_RECRUITMENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 42: ,per_assignment_status_types ast

38: ,ast.per_system_status
39: ,ias.status_change_reason
40: FROM
41: irc_assignment_statuses ias
42: ,per_assignment_status_types ast
43: WHERE ias.assignment_status_type_id = ast.assignment_status_type_id
44: AND ias.assignment_id = p_assignment_id;
45: */
46:

Line 54: ,per_assignment_status_types ast

50: ,ast.per_system_status
51: ,asg.change_reason status_change_reason
52: FROM
53: per_all_assignments_f asg
54: ,per_assignment_status_types ast
55: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
56: AND asg.assignment_id = p_assignment_id;
57:
58: CURSOR success_csr(cp_person_id NUMBER