APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_NOTES_INTERFACE

Line 152: DELETE FROM OKS_NOTES_INTERFACE

148: AND BATCH_ID = P_batch_id
149: AND INTERFACE_STATUS = 'S');
150: l_stmt_num := 50;
151:
152: DELETE FROM OKS_NOTES_INTERFACE
153: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE
154: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
155: AND BATCH_ID = P_batch_id
156: AND INTERFACE_STATUS = 'S')