APPS.PAY_GB_RTI_EYU dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 478: FROM per_absence_attendance_types

474: FROM per_absence_attendances
475: WHERE person_id = c_person_id
476: AND ABSENCE_ATTENDANCE_TYPE_ID IN
477: (SELECT ABSENCE_ATTENDANCE_TYPE_ID
478: FROM per_absence_attendance_types
479: WHERE ABSENCE_CATEGORY IN ('GB_ADDL_PAT_ADOPT', 'GB_ADDL_PAT_BIRTH')
480: )
481: )
482: AND EVIDENCE_STATUS = 'CURRENT';