APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_RET_STRMS

Line 128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');

124: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
125: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
126: commit;
127:
128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');
129:
130:
131: DELETE FROM OKL_SIF_RET_STRMS
132: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

Line 131: DELETE FROM OKL_SIF_RET_STRMS

127:
128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');
129:
130:
131: DELETE FROM OKL_SIF_RET_STRMS
132: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
133: WHERE rets.transaction_number = str.transaction_number
134: and str.creation_date < l_end_date
135: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',