APPS.SSP_SMP_PKG dependencies on SSP_MATERNITIES

Line 213: from ssp_maternities MATERNITY,

209: person.date_of_death,
210: service.date_start,
211: nvl (service.final_process_date, hr_general.end_of_time)
212: FINAL_PROCESS_DATE
213: from ssp_maternities MATERNITY,
214: per_all_people_f PERSON,
215: per_periods_of_service SERVICE
216: where person.person_id = maternity.person_id
217: and person.person_id = service.person_id

Line 426: from ssp_maternities

422: function MATERNITY_RECORD_EXISTS (p_person_id in number) return boolean is
423: --
424: cursor maternity_record is
425: select 1
426: from ssp_maternities
427: where person_id = p_person_id;
428: --
429: l_dummy number (1);
430: l_maternity_record_exists boolean;

Line 2114: from ssp_maternities

2110: --
2111: -- Find out if the maternity exists
2112: --
2113: select 1
2114: from ssp_maternities
2115: where maternity_id = p_maternity_id;
2116: --
2117: cursor csr_entries is
2118: --

Line 2135: from ssp_maternities mat,

2131: and entry.assignment_id = paaf.assignment_id;
2132: --
2133: cursor csr_count_absences is
2134: select count(*)
2135: from ssp_maternities mat,
2136: per_absence_attendances ab
2137: where mat.maternity_id = p_maternity_id
2138: and ab.person_id = mat.person_id
2139: and ab.maternity_id = mat.maternity_id;

Line 2293: from ssp_maternities mat

2289: -- Find any maternity whose SMP figures rely on the earnings
2290: -- calculation.
2291: --
2292: select mat.maternity_id
2293: from ssp_maternities mat
2294: where mat.person_id = p_person_id
2295: and p_effective_date = decode(mat.leave_type,
2296: 'AD',ssp_sap_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2297: 'PA',ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),

Line 2339: from ssp_maternities MATERNITY,

2335: -- Get any maternity which may be affected by the death of the person,
2336: -- where the date of death falls within the MPP and leave is recorded.
2337: --
2338: select maternity.maternity_id
2339: from ssp_maternities MATERNITY,
2340: pay_element_types_f ELEMENT
2341: where maternity.person_id = p_person_id
2342: and element.legislation_code = 'GB'
2343: and element.element_name = c_SMP_element_name

Line 2408: from ssp_maternities

2404: l_max_mpp number;
2405:
2406: cursor get_person_details is
2407: select mpp_start_date, due_date
2408: from ssp_maternities
2409: where maternity_id = p_maternity_id;
2410:
2411: cursor get_maximum_mpp is
2412: select to_number(element_information4)