APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_RET_LEVELS

Line 107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');

103: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
104: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
105: commit;
106:
107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');
108:
109:
110: DELETE FROM OKL_SIF_RET_LEVELS
111: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

Line 110: DELETE FROM OKL_SIF_RET_LEVELS

106:
107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');
108:
109:
110: DELETE FROM OKL_SIF_RET_LEVELS
111: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
112: WHERE rets.transaction_number = str.transaction_number
113: and str.creation_date < l_end_date
114: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',