[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT try.id
FROM okl_trx_types_tl try --okl_trx_types_v try --sechawla 6-may-09 8491816
WHERE try.name = p_trx_name;
SELECT nvl(kle.residual_value,0), cle.sts_code
FROM okl_k_lines kle, okc_k_lines_b cle
WHERE kle.id = p_kle_id
AND kle.id = cle.id;
select PART_TRMNT_APPLY_ROUND_DIFF into l_ael_apply_diff
from OKL_SYSTEM_PARAMS;
IF p_formula_name IS NOT NULL THEN -- User has selected a formula
G_FORMULA_VALUE_FOUND := TRUE;
SELECT cim.object1_id1 kle_id -- original asset id
FROM okc_k_lines_b lnk,
okc_line_styles_b lnk_lse,
okc_statuses_b sts,
okc_k_items cim
WHERE lnk.id = cim.cle_id
AND lnk.dnz_chr_id = cim.dnz_chr_id
AND lnk.lse_id = lnk_lse.id
AND lnk_lse.lty_code in ('LINK_FEE_ASSET','LINK_SERV_ASSET')
AND sts.code = lnk.sts_code
AND sts.ste_code not in ('EXPIRED','TERMINATED','CANCELLED')
AND cim.jtot_object1_code = 'OKX_COVASST'
AND cim.cle_id = to_char(p_link_line_id)
AND cim.object1_id2 = '#';
SELECT '1'
FROM okc_k_lines_b cle,
okc_line_styles_b lse,
okc_k_items cim,
okc_k_lines_v clep,
okc_line_styles_b lsep,
OKL_K_LINES kle
WHERE cle.lse_id = lse.id
AND lse.lty_code = 'LINK_FEE_ASSET'
AND cim.cle_id = cle.id
AND cle.cle_id = clep.id
AND clep.lse_id = lsep.id
AND lsep.lty_code = 'FEE'
AND clep.id = kle.id
AND clep.chr_id = cp_chr_id
AND cim.object1_id1 = cp_asset_id
AND kle.fee_type = cp_fee_type;
SELECT f.id, f.formula_string
FROM okl_formulae_v f
WHERE f.name = cp_formula_name
AND f.start_date <= SYSDATE
AND NVL (f.end_date, sysdate) >= SYSDATE;
SELECT o.name
FROM okl_formulae_v f,
okl_fmla_oprnds_v l,
okl_operands_v o
WHERE f.id = cp_formula_id
AND l.fma_id = f.id
AND l.label = cp_operand_label
AND o.id = l.opd_id;
SELECT f.id, f.formula_string
FROM okl_formulae_v f
WHERE f.name = cp_formula_name
AND f.start_date <= SYSDATE
AND NVL (f.end_date, sysdate) >= SYSDATE;
SELECT o.name
FROM okl_formulae_v f,
okl_fmla_oprnds_v l,
okl_operands_v o
WHERE f.id = cp_formula_id
AND l.fma_id = f.id
AND l.label = cp_operand_label
AND o.id = l.opd_id;
SELECT upper(nvl(qte.partial_yn,'N')) partial_yn
FROM OKL_TRX_QUOTES_B QTE
WHERE QTE.ID = p_qte_id;
l_asset_tbl.DELETE; -- rmunjulu 4300443
Select cim.object1_id1 kle_id -- original asset id
From okc_k_lines_b lnk,
okc_line_styles_b lnk_lse,
okc_statuses_b sts,
okc_k_items cim
Where lnk.id = cim.cle_id
and lnk.dnz_chr_id = cim.dnz_chr_id
and lnk.lse_id = lnk_lse.id
and lnk_lse.lty_code in ('LINK_FEE_ASSET','LINK_SERV_ASSET')
and sts.code = lnk.sts_code
and sts.ste_code not in ('EXPIRED','TERMINATED','CANCELLED')
and cim.jtot_object1_code = 'OKX_COVASST'
and cim.cle_id = to_char(p_link_line_id)
and cim.object1_id2 = '#';
SELECT SUM (NVL (a.floor_price, 0)) floor_price
FROM okl_asset_returns_b a
WHERE a.id = cp_art_id
AND a.kle_id = cp_cle_id;
SELECT SUM (NVL (a.floor_price, 0)) floor_price
FROM okl_asset_returns_b a
WHERE a.id = cp_art_id;
SELECT 'Y'
FROM okc_k_lines_b l,
okc_line_styles_b s
WHERE l.id = cp_line_id
AND s.id = l.lse_id
AND s.lty_code = G_FIN_ASSET_STYLE;
SELECT sysdate INTO G_SYSDATE from dual;
'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
OKL_TQL_PVT.insert_row_bulk(
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);
'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
ELSE -- Non termination quotes use normal insert
IF l_tqlv_tbl.COUNT > 0 THEN
IF (is_debug_statement_on) THEN
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);
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);
'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);