[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT (NVL(term_duration,0) * 30) term_days
FROM okl_k_headers
WHERE id = p_contract_id;
select khr.start_date
, NVL(rpm.catchup_start_date, khr.start_date) catchup_start_date
, NVL(rpm.catchup_frequency_code, 'MONTHLY') catchup_frequency_code
, khr.end_date end_date
from okc_k_headers_b khr
, okl_k_rate_params rpm
where khr.id = rpm.khr_id
and khr.id = cp_khr_id;
select khr.date_last_interim_interest_cal date_last_interim_interest_cal
, NVL(rpm.catchup_start_date, khr.start_date) catchup_start_date
, NVL(rpm.catchup_frequency_code, 'MONTHLY') catchup_frequency_code
, NVL(khr.date_terminated, khr.end_date) end_date
from okl_k_headers_full_v khr
, okl_k_rate_params rpm
where khr.id = rpm.khr_id
and khr.id = cp_khr_id;
SELECT nvl(SUM(nvl(amount, 0)),0) pmt_amt
FROM
okl_strm_elements sel
,okl_streams str
,okl_strm_type_b sty
WHERE sel.stm_id = str.id
AND str.khr_id = cp_khr_id
AND str.say_code = 'CURR'
AND str.active_yn = 'Y'
--Bug# 12903938
AND sel.stream_element_date BETWEEN cp_start_date AND cp_due_date
AND str.sty_id = sty.id
AND sty.stream_type_purpose = cp_stream_type_purpose
AND str.kle_id = cp_kle_id;
SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
FROM okl_strm_type_b sty_prin_pmt,
okl_streams stm_prin_pmt,
okl_strm_elements sel_prin_pmt
WHERE stm_prin_pmt.khr_id = cp_khr_id
AND stm_prin_pmt.id = sel_prin_pmt.stm_id
AND sel_prin_pmt.stream_element_date >= cp_start_date
AND stm_prin_pmt.sty_id = sty_prin_pmt.id
AND stm_prin_pmt.active_yn = 'Y'
AND stm_prin_pmt.say_code = 'CURR'
AND sty_prin_pmt.stream_type_purpose = cp_stream_type_purpose
AND stm_prin_pmt.kle_id = cp_kle_id;
SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
FROM okl_strm_type_v sty_prin_pmt,
okl_streams_v stm_prin_pmt,
okl_strm_elements_v sel_prin_pmt
WHERE stm_prin_pmt.khr_id = cp_khr_id
AND stm_prin_pmt.id = sel_prin_pmt.stm_id
AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
AND stm_prin_pmt.sty_id = sty_prin_pmt.id
AND stm_prin_pmt.active_yn = 'Y'
AND stm_prin_pmt.say_code = 'CURR'
AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_CATCHUP'
AND stm_prin_pmt.kle_id = cp_kle_id;
SELECT contract_number
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT cle.id
FROM okc_k_lines_b cle,
okc_statuses_b sts
WHERE cle.lse_id = OKL_VARIABLE_INTEREST_PVT.G_FIN_LINE_LTY_ID
AND cle.dnz_chr_id = p_contract_id
AND cle.chr_id = p_contract_id
AND cle.sts_code = sts.code
AND sts.ste_code NOT IN ('TERMINATED', 'CANCELLED');
OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
p_api_version => 1.0,
p_init_msg_list => OKL_API.G_TRUE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
p_api_version => 1.0,
p_init_msg_list => OKL_API.G_TRUE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
p_api_version => 1.0,
p_init_msg_list => OKL_API.G_TRUE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
p_api_version => 1.0,
p_init_msg_list => OKL_API.G_TRUE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
OKL_VR_DATA_HANDLER_PVT.insert_principal_bal_txn(
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_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
OKL_VR_DATA_HANDLER_PVT.UPDATE_LAST_INT_CAL_DATE(
p_api_version => p_api_version,
p_init_msg_list => Okl_Api.G_TRUE,
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_catchup_date);