APPS.SSP_SAP_PKG dependencies on SSP_MATERNITIES

Line 89: ssp_maternities MATERNITY,

85: person.date_of_death,
86: service.date_start,
87: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
88: from
89: ssp_maternities MATERNITY,
90: per_all_people_f PERSON,
91: per_periods_of_service SERVICE
92: where
93: person.person_id = maternity.person_id

Line 252: from ssp_maternities

248: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
249: --
250: cursor maternity_record is
251: select 1
252: from ssp_maternities
253: where person_id = p_person_id;
254: --
255: l_dummy number (1);
256: l_maternity_record_exists boolean;

Line 1752: from ssp_maternities

1748: --
1749: -- Find out if the maternity exists
1750: --
1751: select 1
1752: from ssp_maternities
1753: where maternity_id = p_maternity_id;
1754: --
1755: cursor csr_entries is
1756: --

Line 1773: from ssp_maternities mat,

1769: and entry.assignment_id = paaf.assignment_id;
1770: --
1771: cursor csr_count_absences is
1772: select count(*)
1773: from ssp_maternities mat,
1774: per_absence_attendances ab
1775: where mat.maternity_id = p_maternity_id
1776: and ab.person_id = mat.person_id
1777: and ab.maternity_id = mat.maternity_id;

Line 1838: from ssp_maternities

1834: l_max_mpp number;
1835:
1836: cursor get_person_details is
1837: select mpp_start_date, due_date
1838: from ssp_maternities
1839: where maternity_id = p_maternity_id;
1840:
1841: cursor get_maximum_mpp is
1842: select to_number(element_information3)