APPS.SSP_PAB_PKG dependencies on SSP_MATERNITIES

Line 91: from ssp_maternities MATERNITY,

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

Line 283: from ssp_maternities

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

Line 1685: from ssp_maternities

1681: --
1682: -- Find out if the maternity exists
1683: --
1684: select 1
1685: from ssp_maternities
1686: where maternity_id = p_maternity_id;
1687: --
1688: cursor csr_entries is
1689: --

Line 1706: from ssp_maternities mat,

1702: and entry.assignment_id = paaf.assignment_id;
1703: --
1704: cursor csr_count_absences is
1705: select count(*)
1706: from ssp_maternities mat,
1707: per_absence_attendances ab
1708: where mat.maternity_id = p_maternity_id
1709: and ab.person_id = mat.person_id
1710: and ab.maternity_id = mat.maternity_id;