APPS.SSP_SMP_PKG dependencies on SSP_MATERNITIES

Line 220: from ssp_maternities MATERNITY,

216: person.date_of_death,
217: service.date_start,
218: nvl (service.final_process_date, hr_general.end_of_time)
219: FINAL_PROCESS_DATE
220: from ssp_maternities MATERNITY,
221: per_all_people_f PERSON,
222: per_periods_of_service SERVICE
223: where person.person_id = maternity.person_id
224: and person.person_id = service.person_id

Line 433: from ssp_maternities

429: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
430: --
431: cursor maternity_record is
432: select 1
433: from ssp_maternities
434: where person_id = p_person_id;
435: --
436: l_dummy number (1);
437: l_maternity_record_exists boolean;

Line 2193: from ssp_maternities

2189: --
2190: -- Find out if the maternity exists
2191: --
2192: select 1
2193: from ssp_maternities
2194: where maternity_id = p_maternity_id;
2195: --
2196: cursor csr_entries is
2197: --

Line 2214: from ssp_maternities mat,

2210: and entry.assignment_id = paaf.assignment_id;
2211: --
2212: cursor csr_count_absences is
2213: select count(*)
2214: from ssp_maternities mat,
2215: per_absence_attendances ab
2216: where mat.maternity_id = p_maternity_id
2217: and ab.person_id = mat.person_id
2218: and ab.maternity_id = mat.maternity_id;

Line 2372: from ssp_maternities mat

2368: -- Find any maternity whose SMP figures rely on the earnings
2369: -- calculation.
2370: --
2371: select mat.maternity_id
2372: from ssp_maternities mat
2373: where mat.person_id = p_person_id
2374: and p_effective_date = decode(mat.leave_type,
2375: 'AD',ssp_sap_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2376: 'PA',ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),

Line 2420: from ssp_maternities MATERNITY,

2416: -- Get any maternity which may be affected by the death of the person,
2417: -- where the date of death falls within the MPP and leave is recorded.
2418: --
2419: select maternity.maternity_id
2420: from ssp_maternities MATERNITY,
2421: pay_element_types_f ELEMENT
2422: where maternity.person_id = p_person_id
2423: and element.legislation_code = 'GB'
2424: and element.element_name = c_SMP_element_name

Line 2489: from ssp_maternities

2485: l_max_mpp number;
2486:
2487: cursor get_person_details is
2488: select mpp_start_date, due_date
2489: from ssp_maternities
2490: where maternity_id = p_maternity_id;
2491:
2492: cursor get_maximum_mpp is
2493: select to_number(element_information4)