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')