APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 556: per_absence_attendances ab

552: --
553: cursor csr_count_absences(p_maternity_id number) is
554: select count(*)
555: from ssp_maternities mat,
556: per_absence_attendances ab
557: where mat.maternity_id = p_maternity_id
558: and ab.person_id = mat.person_id
559: and ab.maternity_id = mat.maternity_id;
560: --

Line 969: from per_absence_attendances paa,

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

Line 1017: from per_absence_attendances paa,

1013: paa.date_start,
1014: paa.date_end,
1015: paa.date_projected_start,
1016: paa.date_projected_end
1017: from per_absence_attendances paa,
1018: ssp_maternities mat
1019: where paa.maternity_id = mat.maternity_id
1020: and nvl(mat.leave_type, 'MA') = p_leave_type
1021: and

Line 2257: from per_absence_attendances paa,

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

Line 2305: from per_absence_attendances paa,

2301: paa.date_start,
2302: paa.date_end,
2303: paa.date_projected_start,
2304: paa.date_projected_end
2305: from per_absence_attendances paa,
2306: ssp_maternities mat
2307: where paa.maternity_id = mat.maternity_id
2308: and nvl(mat.leave_type, 'MA') = p_leave_type
2309: and