APPS.SSP_PAB_PKG dependencies on SSP_MATERNITIES

Line 88: from ssp_maternities MATERNITY,

84: maternity.pay_SMP_as_lump_sum pay_PAB_as_lump_sum,
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 ssp_maternities MATERNITY,
89: per_all_people_f PERSON,
90: per_periods_of_service SERVICE
91: where person.person_id = maternity.person_id
92: and person.person_id = service.person_id

Line 280: from ssp_maternities

276: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
277: --
278: cursor maternity_record is
279: select 1
280: from ssp_maternities
281: where person_id = p_person_id;
282: --
283: l_dummy number (1);
284: l_maternity_record_exists boolean;

Line 1676: from ssp_maternities

1672: --
1673: -- Find out if the maternity exists
1674: --
1675: select 1
1676: from ssp_maternities
1677: where maternity_id = p_maternity_id;
1678: --
1679: cursor csr_entries is
1680: --

Line 1697: from ssp_maternities mat,

1693: and entry.assignment_id = paaf.assignment_id;
1694: --
1695: cursor csr_count_absences is
1696: select count(*)
1697: from ssp_maternities mat,
1698: per_absence_attendances ab
1699: where mat.maternity_id = p_maternity_id
1700: and ab.person_id = mat.person_id
1701: and ab.maternity_id = mat.maternity_id;