APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_STREAM_TYPES

Line 70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');

66: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
67: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
68: commit;
69:
70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');
71:
72:
73: DELETE FROM OKL_SIF_STREAM_TYPES
74: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

Line 73: DELETE FROM OKL_SIF_STREAM_TYPES

69:
70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');
71:
72:
73: DELETE FROM OKL_SIF_STREAM_TYPES
74: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
75: WHERE creation_date < l_end_date
76: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
77: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));