APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_YIELDS

Line 80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');

76: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
77: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
78: commit;
79:
80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');
81:
82: DELETE FROM OKL_SIF_YIELDS
83: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
84: WHERE creation_date < l_end_date

Line 82: DELETE FROM OKL_SIF_YIELDS

78: commit;
79:
80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');
81:
82: DELETE FROM OKL_SIF_YIELDS
83: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
84: WHERE creation_date < l_end_date
85: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
86: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));