APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1796: FROM per_absence_attendance_types

1792: FROM per_absence_attendances
1793: WHERE person_id = c_person_id
1794: AND ABSENCE_ATTENDANCE_TYPE_ID IN
1795: (SELECT ABSENCE_ATTENDANCE_TYPE_ID
1796: FROM per_absence_attendance_types
1797: WHERE ABSENCE_CATEGORY IN ('GB_ADDL_PAT_ADOPT', 'GB_ADDL_PAT_BIRTH')
1798: )
1799: )
1800: AND EVIDENCE_STATUS = 'CURRENT';