DBA Data[Home] [Help]

APPS.SSP_APAD_PKG dependencies on SSP_STOPPAGES

Line 463: from ssp_stoppages

459: -- Remove old system, non-overridden stoppages
460: --
461: cursor csr_stoppages is
462: select stoppage_id
463: from ssp_stoppages
464: where user_entered <>'Y'
465: and override_stoppage <> 'Y'
466: and maternity_id = p_maternity_id;
467: --

Line 1047: from ssp_stoppages

1043: --
1044: cursor csr_stoppages is
1045: --
1046: select stoppage_id
1047: from ssp_stoppages
1048: where user_entered <>'Y'
1049: and override_stoppage <> 'Y'
1050: and maternity_id = p_maternity_id;
1051: --

Line 1355: from ssp_stoppages STP,

1351: --
1352: -- Find any non-overridden stoppages
1353: --
1354: select wre.reason, stp.withhold_from, stp.withhold_to
1355: from ssp_stoppages STP,
1356: ssp_withholding_reasons WRE
1357: where stp.override_stoppage <> 'Y'
1358: --
1359: -- and the stoppage ovelaps the period or the stoppage is for