The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT qte.id,
qte.khr_id,
qte.term,
qte.pop_code_end,
qte.purchase_amount,
qte.purchase_formula,
khr.after_tax_yield,
khr.term_duration
FROM okl_trx_quotes_v qte,
okl_k_headers khr
WHERE qte.id = p_quote_id
AND khr.id = qte.khr_id;
SELECT ste.stream_element_date start_date,
SUM (ste.amount) amount
FROM okl_strm_elements ste,
okl_streams stm,
okc_k_lines_b kle,
okc_statuses_b kls
WHERE stm.khr_id = cp_contract_id
AND stm.sty_id = cp_sty_id
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND kle.id = stm.kle_id
AND kls.code = kle.sts_code
AND kls.ste_code = 'ACTIVE'
AND ste.stm_id = stm.id
GROUP BY ste.stream_element_date
ORDER BY ste.stream_element_date;
lx_req_stream_types_tbl.DELETE;
lx_rents_tbl.DELETE;
-- Update quote status
-- *******************
l_qtev_rec.id := p_quote_id;
OKL_TRX_QUOTES_PUB.update_trx_quotes (
p_api_version => l_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_qtev_rec => l_qtev_rec,
x_qtev_rec => lx_qtev_rec);
OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines (
p_api_version => l_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tqlv_tbl => l_tqlv_tbl,
x_tqlv_tbl => lx_tqlv_tbl);