504: -- Remove old system, non-overridden stoppages
505: --
506: cursor csr_stoppages is
507: select stoppage_id
508: from ssp_stoppages
509: where user_entered <>'Y'
510: and override_stoppage <> 'Y'
511: and maternity_id = p_maternity_id;
512: --
1123: -- Remove old system, non-overridden stoppages
1124: --
1125: cursor csr_stoppages is
1126: select stoppage_id
1127: from ssp_stoppages
1128: where user_entered <>'Y'
1129: and override_stoppage <> 'Y'
1130: and maternity_id = p_maternity_id;
1131: --
1433: --
1434: -- Find any non-overridden stoppages
1435: --
1436: select wre.reason, stp.withhold_from, stp.withhold_to
1437: from ssp_stoppages STP,
1438: ssp_withholding_reasons WRE
1439: where stp.override_stoppage <> 'Y'
1440: --
1441: -- and the stoppage ovelaps the period or the stoppage is for