APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on SSP_SMP_PKG

Line 304: ssp_smp_pkg.earliest_MPP_start_date (due_date))

300: decode(leave_type,
301: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
302: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
303: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
304: ssp_smp_pkg.earliest_MPP_start_date (due_date))
305: earliest_MPP_start_date
306: from ssp_maternities
307: where maternity_id = p_maternity_id;
308: --

Line 381: ssp_smp_pkg.earliest_MPP_start_date (due_date))

377: decode(leave_type,
378: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
379: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
380: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
381: ssp_smp_pkg.earliest_MPP_start_date (due_date))
382: earliest_MPP_start_date,
383: ssp_smp_pkg.qualifying_week (due_date) QW,
384: nvl(mpp_start_date,hr_general.end_of_time) MPP,
385: person_id,

Line 383: ssp_smp_pkg.qualifying_week (due_date) QW,

379: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
380: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
381: ssp_smp_pkg.earliest_MPP_start_date (due_date))
382: earliest_MPP_start_date,
383: ssp_smp_pkg.qualifying_week (due_date) QW,
384: nvl(mpp_start_date,hr_general.end_of_time) MPP,
385: person_id,
386: leave_type,
387: placement_date,

Line 2835: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,

2831: --
2832: Procedure check_val_abs_start (p_date_start in date,
2833: p_maternity_id in number) is
2834: Cursor csr_maternity is
2835: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2836: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2837: nvl(mat.leave_type,'MA') leave_type
2838: from ssp_maternities MAT
2839: where mat.maternity_id = p_maternity_id;

Line 2942: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;

2938: p_date_start in date,
2939: p_effective_date in date,
2940: p_element_name in varchar2) return boolean is
2941:
2942: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;
2943:
2944: BEGIN
2945: hr_utility.set_location
2946: ('per_absence_attendances_pkg.late_abs_notification',1);

Line 2947: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,

2943:
2944: BEGIN
2945: hr_utility.set_location
2946: ('per_absence_attendances_pkg.late_abs_notification',1);
2947: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
2948: p_element_name);
2949: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
2950: close ssp_SMP_pkg.csr_SMP_element_details;
2951: if p_date_notification >

Line 2949: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;

2945: hr_utility.set_location
2946: ('per_absence_attendances_pkg.late_abs_notification',1);
2947: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
2948: p_element_name);
2949: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
2950: close ssp_SMP_pkg.csr_SMP_element_details;
2951: if p_date_notification >
2952: (p_date_start -
2953: to_number(l_element_details.mpp_notice_requirement)) then

Line 2950: close ssp_SMP_pkg.csr_SMP_element_details;

2946: ('per_absence_attendances_pkg.late_abs_notification',1);
2947: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
2948: p_element_name);
2949: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;
2950: close ssp_SMP_pkg.csr_SMP_element_details;
2951: if p_date_notification >
2952: (p_date_start -
2953: to_number(l_element_details.mpp_notice_requirement)) then
2954: -- Added explicit number conversion above. Bug 3111653