APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_MATERNITIES

Line 494: from ssp_maternities

490: for update;
491: --
492: cursor csr_leave_type (p_maternity_id number) is
493: select leave_type
494: from ssp_maternities
495: where maternity_id = p_maternity_id;
496:
497: cursor csr_affected_PIWs is
498: --

Line 514: from ssp_maternities mat,

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

Line 973: ssp_maternities mat

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

Line 2009: ssp_maternities mat

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