APPS.SSP_SAP_PKG dependencies on SSP_MATERNITIES

Line 87: ssp_maternities MATERNITY,

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

Line 250: from ssp_maternities

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

Line 1745: from ssp_maternities

1741: --
1742: -- Find out if the maternity exists
1743: --
1744: select 1
1745: from ssp_maternities
1746: where maternity_id = p_maternity_id;
1747: --
1748: cursor csr_entries is
1749: --

Line 1766: from ssp_maternities mat,

1762: and entry.assignment_id = paaf.assignment_id;
1763: --
1764: cursor csr_count_absences is
1765: select count(*)
1766: from ssp_maternities mat,
1767: per_absence_attendances ab
1768: where mat.maternity_id = p_maternity_id
1769: and ab.person_id = mat.person_id
1770: and ab.maternity_id = mat.maternity_id;

Line 1831: from ssp_maternities

1827: l_max_mpp number;
1828:
1829: cursor get_person_details is
1830: select mpp_start_date, due_date
1831: from ssp_maternities
1832: where maternity_id = p_maternity_id;
1833:
1834: cursor get_maximum_mpp is
1835: select to_number(element_information3)