APPS.PAY_GB_RTI_FPS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1286: FROM per_absence_attendance_types

1282: FROM per_absence_attendances
1283: WHERE person_id = c_person_id
1284: AND ABSENCE_ATTENDANCE_TYPE_ID IN
1285: (SELECT ABSENCE_ATTENDANCE_TYPE_ID
1286: FROM per_absence_attendance_types
1287: WHERE ABSENCE_CATEGORY IN ('GB_ADDL_PAT_ADOPT', 'GB_ADDL_PAT_BIRTH')
1288: )
1289: )
1290: AND EVIDENCE_STATUS = 'CURRENT';