APPS.HRI_OPL_RECRUITMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 53: per_all_assignments_f asg

49: asg.effective_start_date status_change_date
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:

Line 62: FROM per_all_assignments_f asg

58: CURSOR success_csr(cp_person_id NUMBER
59: ,cp_assignment_id NUMBER
60: ,cp_end_date DATE) IS
61: SELECT 'Y', asg.change_reason, asg.assignment_id
62: FROM per_all_assignments_f asg
63: WHERE asg.person_id = cp_person_id
64: AND asg.effective_start_date = cp_end_date + 1
65: AND (asg.assignment_id = cp_assignment_id
66: OR asg.primary_flag = 'Y')