APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 970: per_absence_attendance_types paat

966: paa.person_id,
967: nvl(paa.date_start,paa.sickness_start_date) as absence_start_date,
968: nvl(paa.date_end,paa.sickness_end_date) as absence_end_date
969: from per_absence_attendances paa,
970: per_absence_attendance_types paat
971: where paa.absence_attendance_type_id = paat.absence_attendance_type_id
972: and paat.absence_category = 'S'
973: and
974: /* SSP absences which span tax years or start in old tax year and are open-ended */

Line 2258: per_absence_attendance_types paat

2254: paa.person_id,
2255: nvl(paa.date_start,paa.sickness_start_date) as absence_start_date,
2256: nvl(paa.date_end,paa.sickness_end_date) as absence_end_date
2257: from per_absence_attendances paa,
2258: per_absence_attendance_types paat
2259: where paa.absence_attendance_type_id = paat.absence_attendance_type_id
2260: and paat.absence_category = 'S'
2261: and
2262: /* SSP absences which span tax years or start in old tax year and are open-ended */