APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_FEES

Line 53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');

49: --l_end_date := TO_DATE(p_end_date,'YYYY/MM/DD HH:MI:SS');
50: l_end_date := fnd_date.canonical_to_date(p_end_date);
51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);
52:
53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');
54:
55: DELETE FROM OKL_SIF_FEES
56: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
57: WHERE creation_date < l_end_date

Line 55: DELETE FROM OKL_SIF_FEES

51: FND_FILE.Put_Line(FND_FILE.LOG, 'Deleting records with creation date less then '||l_end_date);
52:
53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');
54:
55: DELETE FROM OKL_SIF_FEES
56: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
57: WHERE creation_date < l_end_date
58: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
59: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));