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 2489: l_SMP_element ssp_SMP_pkg.csr_SMP_element_details%rowtype;

2485: maximum_SSP_paid exception;
2486: PIW_max_length_reached exception;
2487: stoppage_invoked exception;
2488: l_stoppage_overridden boolean := FALSE;
2489: l_SMP_element ssp_SMP_pkg.csr_SMP_element_details%rowtype;
2490: --
2491: type stoppage_table_type is record (t_withheld_from date_table,
2492: t_withheld_to date_table);
2493: --

Line 2704: ssp_smp_pkg.expected_week_of_confinement(due_date) EWC

2700: select maternity_id,
2701: object_version_number,
2702: MPP_start_date,
2703: due_date, -- Need due_date to decide on value of sickness_trigger_weeks
2704: ssp_smp_pkg.expected_week_of_confinement(due_date) EWC
2705: from ssp_maternities
2706: where person_id = p_absence.person_id
2707: and nvl(leave_type,'MA') = 'MA';
2708:

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

2981: begin
2982: -- Start of do_PIW_calculations
2983: hr_utility.set_location ('Entering:'||l_proc,1);
2984: --
2985: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2986: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2987: close ssp_SMP_pkg.csr_SMP_element_details;
2988: --
2989: start_disqualifying_period := null;

Line 2986: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;

2982: -- Start of do_PIW_calculations
2983: hr_utility.set_location ('Entering:'||l_proc,1);
2984: --
2985: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2986: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2987: close ssp_SMP_pkg.csr_SMP_element_details;
2988: --
2989: start_disqualifying_period := null;
2990: end_disqualifying_period := null;

Line 2987: close ssp_SMP_pkg.csr_SMP_element_details;

2983: hr_utility.set_location ('Entering:'||l_proc,1);
2984: --
2985: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date => PIW_start_date);
2986: fetch ssp_SMP_pkg.csr_SMP_element_details into l_SMP_element;
2987: close ssp_SMP_pkg.csr_SMP_element_details;
2988: --
2989: start_disqualifying_period := null;
2990: end_disqualifying_period := null;
2991: --