APPS.SSP_SSP_PKG dependencies on SSP_SMP_PKG

Line 18: with ssp_SMP_pkg.c_LEL. Added procedure

14: --
15: History
16: 11 Sep 95 N Simpson Created
17: 19 Sep 95 N Simpson Removed LEL constant and replaced it
18: with ssp_SMP_pkg.c_LEL. Added procedure
19: check_sickness_date_change.
20: 27 Oct 95 N Simpson Renamed all ssp objects to begin with
21: ssp_ instead of hr_
22: 31 Oct 95 N Simpson Added workaround for 10.6 to check

Line 2375: l_SMP_element ssp_SMP_pkg.csr_SMP_element_details%rowtype;

2371: maximum_SSP_paid exception;
2372: PIW_max_length_reached exception;
2373: stoppage_invoked exception;
2374: l_stoppage_overridden boolean := FALSE;
2375: l_SMP_element ssp_SMP_pkg.csr_SMP_element_details%rowtype;
2376: --
2377: type stoppage_table_type is record (t_withheld_from date_table,
2378: t_withheld_to date_table);
2379: --

Line 2590: ssp_smp_pkg.expected_week_of_confinement(due_date) EWC

2586: select maternity_id,
2587: object_version_number,
2588: MPP_start_date,
2589: due_date, -- Need due_date to decide on value of sickness_trigger_weeks
2590: ssp_smp_pkg.expected_week_of_confinement(due_date) EWC
2591: from ssp_maternities
2592: where person_id = p_absence.person_id
2593: and nvl(leave_type,'MA') = 'MA';
2594:

Line 2871: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);

2867: begin
2868: -- Start of do_PIW_calculations
2869: hr_utility.set_location ('Entering:'||l_proc,1);
2870: --
2871: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2872: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2873: close ssp_SMP_pkg.csr_SMP_element_details;
2874: --
2875: start_disqualifying_period := null;

Line 2872: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;

2868: -- Start of do_PIW_calculations
2869: hr_utility.set_location ('Entering:'||l_proc,1);
2870: --
2871: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2872: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2873: close ssp_SMP_pkg.csr_SMP_element_details;
2874: --
2875: start_disqualifying_period := null;
2876: end_disqualifying_period := null;

Line 2873: close ssp_SMP_pkg.csr_SMP_element_details;

2869: hr_utility.set_location ('Entering:'||l_proc,1);
2870: --
2871: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2872: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2873: close ssp_SMP_pkg.csr_SMP_element_details;
2874: --
2875: start_disqualifying_period := null;
2876: end_disqualifying_period := null;
2877: --