APPS.PQP_ABSENCE_PLAN_PROCESS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 26: FROM per_absence_attendance_types paat

22: -- only when there is a overlap.
23: CURSOR csr_absence_type(p_absence_attendance_type_id IN NUMBER)
24: IS
25: SELECT paat.NAME
26: FROM per_absence_attendance_types paat
27: WHERE paat.absence_attendance_type_id = p_absence_attendance_type_id ;
28: --
29: --
30: --

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) )