APPS.SSP_PAD_PKG dependencies on SSP_MATERNITIES

Line 90: from ssp_maternities MATERNITY,

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

Line 243: from ssp_maternities

239: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
240: --
241: cursor maternity_record is
242: select 1
243: from ssp_maternities
244: where person_id = p_person_id;
245: --
246: l_dummy number (1);
247: l_maternity_record_exists boolean;

Line 1588: from ssp_maternities

1584: -- Find out if the maternity exists
1585: --
1586: cursor csr_maternity is
1587: select 1
1588: from ssp_maternities
1589: where maternity_id = p_maternity_id;
1590:
1591: --
1592: -- Get all element entries associated with a maternity

Line 1608: from ssp_maternities mat,

1604: and entry.assignment_id = paaf.assignment_id;
1605: --
1606: cursor csr_count_absences is
1607: select count(*)
1608: from ssp_maternities mat,
1609: per_absence_attendances ab
1610: where mat.maternity_id = p_maternity_id
1611: and ab.person_id = mat.person_id
1612: and ab.maternity_id = mat.maternity_id;