APPS.SSP_SMP_PKG dependencies on SSP_STOPPAGES

Line 21: change in ssp_stoppages table.

17: 8 Sep 95 N Simpson Modified procedure
18: check_entitlement_to_SMP and turned it
19: into a function entitled_to_SMP.
20: 15 Sep 95 N Simpson Various modifications because of
21: change in ssp_stoppages table.
22: 19 Sep 95 N Simpson Modified medical_control parameters.
23: 27 Oct 95 N Simpson Renamed all HR_ prefixed objects to
24: SSP_ prefix if they were SSP-specific.
25: 2 Nov 95 N Simpson Replaced hrstpapi calls with new style

Line 638: from ssp_stoppages

634: -- Remove old system, non-overridden stoppages
635: --
636: cursor csr_stoppages is
637: select stoppage_id
638: from ssp_stoppages
639: where user_entered <>'Y'
640: and override_stoppage <> 'Y'
641: and maternity_id = p_maternity_id;
642: --

Line 1593: from ssp_stoppages

1589: --
1590: cursor csr_stoppages is
1591: --
1592: select stoppage_id
1593: from ssp_stoppages
1594: where user_entered <>'Y'
1595: and override_stoppage <> 'Y'
1596: and maternity_id = p_maternity_id;
1597: --

Line 1929: from ssp_stoppages STP,

1925: --
1926: -- Find any non-overridden stoppages
1927: --
1928: select 1
1929: from ssp_stoppages STP,
1930: ssp_withholding_reasons WRE
1931: where stp.override_stoppage <> 'Y'
1932: --
1933: -- and the stoppage ovelaps the period or the stoppage is for