APPS.SSP_SAP_PKG dependencies on SSP_STOPPAGES

Line 450: from ssp_stoppages

446: -- Remove old system, non-overridden stoppages
447: --
448: cursor csr_stoppages is
449: select stoppage_id
450: from ssp_stoppages
451: where user_entered <>'Y'
452: and override_stoppage <> 'Y'
453: and maternity_id = p_maternity_id;
454: --

Line 1240: from ssp_stoppages

1236: --
1237: cursor csr_stoppages is
1238: --
1239: select stoppage_id
1240: from ssp_stoppages
1241: where user_entered <>'Y'
1242: and override_stoppage <> 'Y'
1243: and maternity_id = p_maternity_id;
1244: --

Line 1546: from ssp_stoppages STP,

1542: --
1543: -- Find any non-overridden stoppages
1544: --
1545: select 1
1546: from ssp_stoppages STP,
1547: ssp_withholding_reasons WRE
1548: where stp.override_stoppage <> 'Y'
1549: --
1550: -- and the stoppage ovelaps the period or the stoppage is for