APPS.SSP_APAD_PKG dependencies on SSP_MATERNITIES

Line 66: from ssp_maternities MATERNITY,

62: maternity.partner_stat_pay_start_date, -- newly added columns
63: person.date_of_death,
64: service.date_start,
65: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
66: from ssp_maternities MATERNITY,
67: per_all_people_f PERSON,
68: per_periods_of_service SERVICE
69: where person.person_id = maternity.person_id
70: and person.person_id = service.person_id

Line 265: from ssp_maternities

261: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
262: --
263: cursor maternity_record is
264: select 1
265: from ssp_maternities
266: where person_id = p_person_id;
267: --
268: l_dummy number (1);
269: l_maternity_record_exists boolean;

Line 1608: from ssp_maternities

1604: -- Find out if the maternity exists
1605: --
1606: cursor csr_maternity is
1607: select 1
1608: from ssp_maternities
1609: where maternity_id = p_maternity_id;
1610:
1611: --
1612: -- Get all element entries associated with a maternity

Line 1628: from ssp_maternities mat,

1624: and entry.assignment_id = paaf.assignment_id;
1625: --
1626: cursor csr_count_absences is
1627: select count(*)
1628: from ssp_maternities mat,
1629: per_absence_attendances ab
1630: where mat.maternity_id = p_maternity_id
1631: and ab.person_id = mat.person_id
1632: and ab.maternity_id = mat.maternity_id;