DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on BEN_PER_IN_LER

Line 41: ben_per_in_ler pil

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
45: AND asg.effective_end_date