APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_PRICING_PARAMS

Line 89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');

85: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
86: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
87: commit;
88:
89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');
90:
91: DELETE FROM OKL_SIF_PRICING_PARAMS
92: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
93: WHERE creation_date < l_end_date

Line 91: DELETE FROM OKL_SIF_PRICING_PARAMS

87: commit;
88:
89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');
90:
91: DELETE FROM OKL_SIF_PRICING_PARAMS
92: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
93: WHERE creation_date < l_end_date
94: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
95: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));