[Home] [Help]
4160:
4161: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
4162: SELECT kle.id,
4163: kle.name
4164: FROM OKC_K_LINES_V kle,
4165: OKC_LINE_STYLES_B ls,
4166: OKC_STATUSES_B sts
4167: WHERE kle.lse_id = ls.id
4168: AND ls.lty_code = ltycode
4521: --Bug# 16098797
4522: top.orig_system_id1,
4523: --Bug# 16681373
4524: NVL(top_kle.re_lease_yn,'N') re_lease_yn
4525: FROM okc_k_lines_v top,
4526: okl_k_lines top_kle,
4527: okc_k_lines_b item,
4528: okc_line_styles_b item_style,
4529: okc_line_styles_b top_style,
6145: for top fee line of a given contract. */
6146:
6147: CURSOR l_rq_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6148: SELECT kle.id, kle.qte_id, kle.amount, cleb.name
6149: FROM okc_k_lines_v cleb,
6150: okl_k_lines kle
6151: WHERE cleb.dnz_chr_id = chrID
6152: AND kle.ID = cleb.ID
6153: AND kle.fee_type = 'ROLLOVER'
6255: AND styt.LANGUAGE = USERENV('LANG')
6256: AND sty.id = styt.id;
6257:
6258: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
6259: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
6260: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
6261: l_qte_id OKL_K_LINES.QTE_ID%TYPE;
6262: l_qte_num OKL_TRX_QUOTES_V.QUOTE_NUMBER%TYPE;
6263: p_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
6618: -- Validation of Sales Tax Financed Fee will be done
6619: -- after the Calculate Upfront Tax process
6620: CURSOR l_fn_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6621: SELECT kle.id, kle.amount, cleb.name
6622: FROM okc_k_lines_v cleb,
6623: okl_k_lines kle,
6624: okc_statuses_b okcsts
6625: WHERE cleb.dnz_chr_id = chrID
6626: AND cleb.chr_id = chrID
6698: AND styt.LANGUAGE = USERENV('LANG')
6699: AND sty.id = styt.id;
6700:
6701: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
6702: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
6703: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
6704: x_err_msg VARCHAR2(1000);
6705:
6706: l_fn_sub_ln_fee_cnt NUMBER := 0;
7530: fin_ast_cle.id rbk_fin_ast_cle_id,
7531: fin_ast_cle.orig_system_id1 orig_fin_ast_cle_id,
7532: fin_ast_cle.name asset_number
7533: FROM okc_k_lines_b model_cle,
7534: okc_k_lines_v fin_ast_cle,
7535: okc_statuses_b sts
7536: WHERE fin_ast_cle.chr_id = p_chr_id
7537: AND fin_ast_cle.dnz_chr_id = p_chr_id
7538: AND fin_ast_cle.lse_id = 33 -- Financial Asset Line
7789: -- Bug 6417667 End
7790: --down_payment_yes_no
7791: FROM
7792: okl_k_lines kle,
7793: okc_k_lines_v cle,
7794: okc_line_styles_b sty,
7795: okc_statuses_b sts
7796: WHERE cle.id = kle.id
7797: AND dnz_chr_id = p_chr_id
9376: CURSOR l_asset_csr IS
9377: SELECT cle.id,
9378: name,
9379: kle.residual_value
9380: FROM okc_k_lines_v cle,
9381: okl_k_lines kle,
9382: okc_line_styles_b sty,
9383: okc_statuses_b sts
9384: WHERE cle.lse_id = sty.id
9536: *
9537: * Cursor l_synd_csr ( chrId NUMBER ) IS
9538: * select kl.dnz_chr_id syndId
9539: * from OKC_K_ITEMS_V ITM,
9540: * OKC_K_LINES_V KL,
9541: * OKL_K_HEADERS_FULL_V KHR,
9542: * OKC_LINE_STYLES_B lse
9543: * where KL.LSE_ID=lse.id
9544: * and lse.lty_code='SHARED'
11045: -- Bug 6497111 Start Udhenuko Added.
11046: AND NVL(line.fee_purpose_code,'XXX') <> 'SALESTAX';
11047: -- Bug 6497111 End
11048:
11049: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
11050: SELECT id,
11051: NVL(capital_amount,0) capital_amount
11052: FROM okl_k_lines_full_v line,
11053: okc_statuses_b sts
12044: SELECT txl.asset_number asset_num,
12045: fa.id fa_id,
12046: txd.tax_book
12047: FROM okc_k_items cim,
12048: okc_k_lines_V fa,
12049: okc_line_styles_b fa_lse,
12050: OKL_TRX_ASSETS trx,
12051: okl_txl_assets_b txl,
12052: okl_txd_assets_v txd,