APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 925: per_absence_attendance_types paat

921: paa.person_id,
922: nvl(paa.date_start,paa.sickness_start_date) as absence_start_date,
923: nvl(paa.date_end,paa.sickness_end_date) as absence_end_date
924: from per_absence_attendances paa,
925: per_absence_attendance_types paat
926: where paa.absence_attendance_type_id = paat.absence_attendance_type_id
927: and paat.absence_category = 'S'
928: and
929: /* SSP absences which span tax years or start in old tax year and are open-ended */

Line 1961: per_absence_attendance_types paat

1957: paa.person_id,
1958: nvl(paa.date_start,paa.sickness_start_date) as absence_start_date,
1959: nvl(paa.date_end,paa.sickness_end_date) as absence_end_date
1960: from per_absence_attendances paa,
1961: per_absence_attendance_types paat
1962: where paa.absence_attendance_type_id = paat.absence_attendance_type_id
1963: and paat.absence_category = 'S'
1964: and
1965: /* SSP absences which span tax years or start in old tax year and are open-ended */