APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 442: ,per_absence_attendances paat

438: CURSOR csr_absence_days(c_person_id NUMBER
439: ,c_termination_year VARCHAR2) IS
440: SELECT SUM(paat.absence_days)
441: FROM per_absence_attendance_types pat
442: ,per_absence_attendances paat
443: WHERE pat.absence_attendance_type_id = paat.absence_attendance_type_id
444: AND pat.absence_category = 'S'
445: AND paat.person_id = c_person_id
446: AND to_char(paat.date_end,'YYYY') = c_termination_year;

Line 459: ,per_absence_attendances paat

455: ,paat.date_start, to_date('01-01-'||c_termination_year,'dd-mm-YYYY'))
456: + 1
457: ) sickness_leave_taken
458: FROM per_absence_attendance_types pat
459: ,per_absence_attendances paat
460: WHERE pat.ABSENCE_ATTENDANCE_TYPE_ID = paat.ABSENCE_ATTENDANCE_TYPE_ID
461: AND pat.ABSENCE_CATEGORY = 'S'
462: AND paat.person_id = c_person_id
463: AND to_char(paat.date_end,'YYYY') = c_termination_year;