APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 515: per_absence_attendances ab

511: --
512: cursor csr_count_absences(p_maternity_id number) is
513: select count(*)
514: from ssp_maternities mat,
515: per_absence_attendances ab
516: where mat.maternity_id = p_maternity_id
517: and ab.person_id = mat.person_id
518: and ab.maternity_id = mat.maternity_id;
519: --

Line 924: from per_absence_attendances paa,

920: select nvl(paa.linked_absence_id,paa.absence_attendance_id) as absence_id,
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

Line 972: from per_absence_attendances paa,

968: paa.date_start,
969: paa.date_end,
970: paa.date_projected_start,
971: paa.date_projected_end
972: from per_absence_attendances paa,
973: ssp_maternities mat
974: where paa.maternity_id = mat.maternity_id
975: and nvl(mat.leave_type, 'MA') = p_leave_type
976: and

Line 1960: from per_absence_attendances paa,

1956: select nvl(paa.linked_absence_id,paa.absence_attendance_id) as absence_id,
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

Line 2008: from per_absence_attendances paa,

2004: paa.date_start,
2005: paa.date_end,
2006: paa.date_projected_start,
2007: paa.date_projected_end
2008: from per_absence_attendances paa,
2009: ssp_maternities mat
2010: where paa.maternity_id = mat.maternity_id
2011: and nvl(mat.leave_type, 'MA') = p_leave_type
2012: and