APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_MATERNITIES

Line 535: from ssp_maternities

531: for update;
532: --
533: cursor csr_leave_type (p_maternity_id number) is
534: select leave_type
535: from ssp_maternities
536: where maternity_id = p_maternity_id;
537:
538: cursor csr_affected_PIWs is
539: --

Line 555: from ssp_maternities mat,

551: for update;
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;

Line 1018: ssp_maternities mat

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
1022: /* SMP absences which span tax years or start in old tax year and are open-ended */

Line 2306: ssp_maternities mat

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
2310: /* SMP absences which span tax years or start in old tax year and are open-ended */