113: AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
114: ,TRUNC(START_DATE))
115: AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
116: ,TRUNC(START_DATE)) );
117: DELETE FROM CE_FORECAST_ERRORS
118: WHERE FORECAST_ID in (
119: SELECT
120: FORECAST_ID
121: FROM
190: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
191: ,TRUNC(GLP.START_DATE))
192: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
193: ,TRUNC(GLP.START_DATE)) ) );
194: DELETE FROM CE_FORECAST_ERRORS
195: WHERE FORECAST_ID in (
196: SELECT
197: FORECAST_ID
198: FROM