APPS.PQP_ABSENCE_PLAN_PROCESS dependencies on PER_ABSENCE_ATTENDANCES

Line 18: FROM per_absence_attendances paa

14: SELECT paa.absence_attendance_id
15: ,paa.date_start
16: ,paa.date_end
17: ,paa.absence_attendance_type_id
18: FROM per_absence_attendances paa
19: WHERE paa.absence_attendance_id = p_absence_attendance_id;
20: --
21: --writting a seperate cursor to get absence type as this is required
22: -- only when there is a overlap.

Line 509: FROM per_absence_attendances a

505: RETURN BOOLEAN IS
506:
507: CURSOR csr_overlap_absence (p_absence_attendance_id NUMBER) IS
508: SELECT 1
509: FROM per_absence_attendances a
510: WHERE a.absence_Attendance_id = p_absence_attendance_id
511: AND EXISTS ( SELECT 1
512: FROM per_absence_attendances b
513: WHERE a.person_id = b.person_id

Line 512: FROM per_absence_attendances b

508: SELECT 1
509: FROM per_absence_attendances a
510: WHERE a.absence_Attendance_id = p_absence_attendance_id
511: AND EXISTS ( SELECT 1
512: FROM per_absence_attendances b
513: WHERE a.person_id = b.person_id
514: AND (
515: (a.date_start BETWEEN b.date_start
516: AND NVL(b.date_end,hr_api.g_eot) )