[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fml.name
FROM okl_formulae_v fml
WHERE fml.id = p_formula_id;
SELECT chrb.id contract_id, cleb.id kle_id,
selb.stream_element_date, selb.amount amount
FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
okc_line_styles_b lseb, okl_strm_type_b styb,
okl_strm_elements selb, okl_streams stmb,
okc_statuses_b sts
WHERE cleb.dnz_chr_id = chrb.id
AND cleb.chr_id = chrb.id
AND chrb.id = p_contract_id
AND cleb.lse_id = lseb.id
AND lseb.lty_code = 'FREE_FORM1'
AND stmb.khr_id = chrb.id
AND stmb.kle_id = cleb.id
AND stmb.sty_id = styb.id
AND selb.stm_id = stmb.id
AND chrb.id = stmb.khr_id
AND stmb.say_code = 'CURR'
AND stmb.active_yn = 'Y'
AND styb.stream_type_purpose = 'RENT'
AND cleb.sts_code = sts.code
AND sts.ste_code NOT IN ('TERMINATED','CANCELLED')
AND (selb.stream_element_date > p_from_date AND selb.stream_element_date <= NVL(p_to_date,trunc(SYSDATE)))
ORDER BY selb.stream_element_date, cleb.id; -- 4904798
OKL_VR_DATA_HANDLER_PVT.UPDATE_LAST_INT_CAL_DATE(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_contract_id => p_contract_id,
p_last_interest_cal_date => l_stream_element_date);