DBA Data[Home] [Help]

APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_SALES_CREDITS_INTERFACE

Line 145: DELETE FROM OKS_SALES_CREDITS_INTERFACE

141: IF l_row_count > 0 THEN
142:
143: l_stmt_num := 40;
144:
145: DELETE FROM OKS_SALES_CREDITS_INTERFACE
146: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE
147: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
148: AND BATCH_ID = P_batch_id
149: AND INTERFACE_STATUS = 'S');