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, per_absence_attendance_types paat

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, per_absence_attendance_types paat
510: WHERE a.absence_Attendance_id = p_absence_attendance_id
511: AND paat.absence_attendance_type_id = a. absence_attendance_type_id -- kvinayku
512: AND EXISTS ( SELECT 1
513: FROM per_absence_attendances b, per_absence_attendance_types paat1

Line 513: FROM per_absence_attendances b, per_absence_attendance_types paat1

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