APPS.SSP_APAB_PKG dependencies on SSP_MATERNITIES

Line 65: from ssp_maternities MATERNITY,

61: maternity.disrupted_placement_date death_of_child,
62: person.date_of_death,
63: service.date_start,
64: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
65: from ssp_maternities MATERNITY,
66: per_all_people_f PERSON,
67: per_periods_of_service SERVICE
68: where person.person_id = maternity.person_id
69: and person.person_id = service.person_id

Line 308: from ssp_maternities

304: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
305: --
306: cursor maternity_record is
307: select 1
308: from ssp_maternities
309: where person_id = p_person_id;
310: --
311: l_dummy number (1);
312: l_maternity_record_exists boolean;

Line 1691: from ssp_maternities

1687: --
1688: -- Find out if the maternity exists
1689: --
1690: select 1
1691: from ssp_maternities
1692: where maternity_id = p_maternity_id;
1693: --
1694: cursor csr_entries is
1695: --

Line 1712: from ssp_maternities mat,

1708: and entry.assignment_id = paaf.assignment_id;
1709: --
1710: cursor csr_count_absences is
1711: select count(*)
1712: from ssp_maternities mat,
1713: per_absence_attendances ab
1714: where mat.maternity_id = p_maternity_id
1715: and ab.person_id = mat.person_id
1716: and ab.maternity_id = mat.maternity_id;