[Home] [Help]
339: WHERE BATCH_ID = LP_BATCH_ID
340: AND ROWNUM = 1;
341: IF (P_TRANSACTION_PROCESS_MODE = 2 AND L_SHOPFLOOR <> 0) THEN
342: NULL;
343: DELETE FROM CST_AP_VARIANCE_LINES CAVL
344: WHERE BATCH_ID = LP_BATCH_ID;
345: DELETE FROM CST_AP_VARIANCE_HEADERS CAVH
346: WHERE BATCH_ID = LP_BATCH_ID;
347: DELETE FROM CST_AP_VARIANCE_BATCHES CAVB