APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_COVERED_LEVELS_INTERFACE
Line 165: DELETE FROM OKS_COVERED_LEVELS_INTERFACE
161: AND OHI.INTERFACE_STATUS = 'S'
162: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);
163: l_stmt_num := 60;
164: 165: DELETE FROM OKS_COVERED_LEVELS_INTERFACE 166: WHERE LINE_INTERFACE_ID IN (SELECT OLI.LINE_INTERFACE_ID
167: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI
168: WHERE OHI.ROWID BETWEEN l_start_rowid AND l_end_rowid
169: AND OHI.BATCH_ID = P_batch_id