DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on SSP_STOPPAGES

Line 479: from ssp_stoppages

475: -- Remove old system, non-overridden stoppages
476: --
477: cursor csr_stoppages is
478: select stoppage_id
479: from ssp_stoppages
480: where user_entered <>'Y'
481: and override_stoppage <> 'Y'
482: and maternity_id = p_maternity_id;
483: --

Line 1160: from ssp_stoppages

1156: -- Remove old system, non-overridden stoppages
1157: --
1158: cursor csr_stoppages is
1159: select stoppage_id
1160: from ssp_stoppages
1161: where user_entered <>'Y'
1162: and override_stoppage <> 'Y'
1163: and maternity_id = p_maternity_id;
1164: --

Line 1469: from ssp_stoppages STP,

1465: --
1466: -- Find any non-overridden stoppages
1467: --
1468: select 1
1469: from ssp_stoppages STP,
1470: ssp_withholding_reasons WRE
1471: where stp.override_stoppage <> 'Y'
1472: --
1473: -- and the stoppage ovelaps the period or the stoppage is for