DBA Data[Home] [Help]

APPS.SSP_PAD_PKG dependencies on SSP_STOPPAGES

Line 440: from ssp_stoppages

436: -- Remove old system, non-overridden stoppages
437: --
438: cursor csr_stoppages is
439: select stoppage_id
440: from ssp_stoppages
441: where user_entered <>'Y'
442: and override_stoppage <> 'Y'
443: and maternity_id = p_maternity_id;
444: --

Line 1075: from ssp_stoppages

1071: --
1072: cursor csr_stoppages is
1073: --
1074: select stoppage_id
1075: from ssp_stoppages
1076: where user_entered <>'Y'
1077: and override_stoppage <> 'Y'
1078: and maternity_id = p_maternity_id;
1079: --

Line 1382: from ssp_stoppages STP,

1378: --
1379: -- Find any non-overridden stoppages
1380: --
1381: select 1
1382: from ssp_stoppages STP,
1383: ssp_withholding_reasons WRE
1384: where stp.override_stoppage <> 'Y'
1385: --
1386: -- and the stoppage ovelaps the period or the stoppage is for