APPS.PSP_WF_ADJ_PKG dependencies on PER_ASSIGNMENTS_F

Line 18: FROM per_assignments_f

14: /*
15: -- Old Cursor
16: CURSOR get_supervisor_id_csr IS
17: SELECT supervisor_id
18: FROM per_assignments_f
19: WHERE person_id = p_person_id
20: AND assignment_number = p_assignment_number
21: AND sysdate between effective_start_date and effective_end_date;
22: */

Line 27: FROM per_assignments_f paf1

23: -- Bug : 1994421. Cursor get_supervisor_id_csr rewritten for Enhancement Employee Assignment for Zero Work days.
24:
25: CURSOR get_supervisor_id_csr IS
26: SELECT paf1.supervisor_id
27: FROM per_assignments_f paf1
28: WHERE paf1.person_id = p_person_id
29: AND paf1.assignment_number = p_assignment_number
30: AND paf1.effective_end_date = (SELECT max(paf2.effective_end_date)
31: FROM per_assignments_f paf2

Line 31: FROM per_assignments_f paf2

27: FROM per_assignments_f paf1
28: WHERE paf1.person_id = p_person_id
29: AND paf1.assignment_number = p_assignment_number
30: AND paf1.effective_end_date = (SELECT max(paf2.effective_end_date)
31: FROM per_assignments_f paf2
32: WHERE paf2.assignment_id = paf1.assignment_id);
33:
34: BEGIN
35: OPEN get_supervisor_id_csr;