DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on SSP_STOPPAGES

Line 482: from ssp_stoppages

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

Line 1169: from ssp_stoppages

1165: -- Remove old system, non-overridden stoppages
1166: --
1167: cursor csr_stoppages is
1168: select stoppage_id
1169: from ssp_stoppages
1170: where user_entered <>'Y'
1171: and override_stoppage <> 'Y'
1172: and maternity_id = p_maternity_id;
1173: --

Line 1478: from ssp_stoppages STP,

1474: --
1475: -- Find any non-overridden stoppages
1476: --
1477: select 1
1478: from ssp_stoppages STP,
1479: ssp_withholding_reasons WRE
1480: where stp.override_stoppage <> 'Y'
1481: --
1482: -- and the stoppage ovelaps the period or the stoppage is for