The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id
FROM mtl_transaction_reasons
WHERE NVL(disable_date, SYSDATE) >= SYSDATE
AND last_update_date >= nvl(p_lastrundate, last_update_date )
AND ( reason_id ) NOT IN (
SELECT reason_id
FROM csm_mtl_txn_reasons_acc
);
SELECT access_id
FROM csm_mtl_txn_reasons_acc acc
, mtl_transaction_reasons mtr
WHERE mtr.reason_id = acc.reason_id
AND NVL(disable_date, SYSDATE) >= SYSDATE
AND mtr.last_update_date >= p_lastrundate;
SELECT access_id
FROM csm_mtl_txn_reasons_acc
WHERE reason_id IN
(SELECT reason_id
FROM mtl_transaction_reasons
WHERE last_update_date >= nvl(p_lastrundate, last_update_date)
AND NVL(disable_date, sysdate) < SYSDATE
)
UNION
SELECT access_id
FROM csm_mtl_txn_reasons_acc
WHERE reason_id NOT IN
(SELECT reason_id
FROM mtl_transaction_reasons
);
SELECT nvl(last_run_date, (sysdate - 365*50))
FROM jtm_con_request_data
WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
FETCH l_last_run_date_csr INTO l_prog_update_date;
l_access_id_tbl.delete;
CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
OPEN l_del_mtl_txn_reasons_csr(l_prog_update_date);
DELETE FROM csm_mtl_txn_reasons_acc WHERE access_id = l_access_id_tbl(i);
l_access_id_tbl.delete;
END IF; -- end of process deletes
CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
OPEN l_upd_mtl_txn_reasons_csr(l_prog_update_date);
l_access_id_tbl.delete;
END IF; -- end of process updates
l_reason_id_tbl.delete;
CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
OPEN l_ins_mtl_txn_reasons_csr(l_prog_update_date);
INSERT INTO csm_mtl_txn_reasons_acc (access_id, reason_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
VALUES (l_access_id_tbl(i), l_reason_id_tbl(i), fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
l_access_id_tbl.delete;
END IF; -- end of process inserts
UPDATE jtm_con_request_data
SET last_run_date = l_run_date
WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';