APPS.PQP_GB_OSP_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 40: FROM per_all_assignments_f asg,

36: -- Cursor to get absence id for a assignment id.
37: CURSOR csr_absence_id(p_assignment_id IN NUMBER, p_effective_date IN DATE)
38: IS
39: SELECT absence_attendance_id
40: FROM per_all_assignments_f asg,
41: ben_per_in_ler pil
42: ,per_absence_attendances paa
43: WHERE asg.assignment_id = p_assignment_id
44: AND p_effective_date BETWEEN asg.effective_start_date

Line 843: ,per_all_assignments_f asg

839: (p_absence_id IN NUMBER
840: ) IS
841: SELECT asg.assignment_id
842: FROM per_absence_attendances abs
843: ,per_all_assignments_f asg
844: WHERE abs.absence_attendance_id = p_absence_id
845: AND asg.person_id = abs.person_id
846: AND NVL(abs.date_start,NVL(abs.sickness_start_date,SYSDATE))
847: BETWEEN asg.effective_start_date