APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_USAGE_COUNTERS_INTERFACE
Line 174: DELETE FROM OKS_USAGE_COUNTERS_INTERFACE
170: AND OHI.INTERFACE_STATUS = 'S'
171: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);
172: l_stmt_num := 70;
173: 174: DELETE FROM OKS_USAGE_COUNTERS_INTERFACE 175: WHERE LINE_INTERFACE_ID IN (SELECT OLI.LINE_INTERFACE_ID
176: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI
177: WHERE OHI.ROWID BETWEEN l_start_rowid AND l_end_rowid
178: AND OHI.BATCH_ID = P_batch_id