[Home] [Help]
1691: IS
1692: -- cursor to fetch the abosrbed fee line with purpose as RVI
1693: CURSOR rvi_fee_csr IS
1694: SELECT KLE.ID ID
1695: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE
1696: WHERE CLE.CHR_ID = p_chr_id
1697: AND CLE.DNZ_CHR_ID = p_chr_id
1698: AND CLE.ID = KLE.ID
1699: AND CLE.LSE_ID = LSE.ID
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_formula_name IN okl_formulae_v.name%TYPE,
2122: p_contract_id IN okl_k_headers_v.id%TYPE,
2123: p_line_id IN okl_k_lines_v.id%TYPE,
2124: x_value OUT NOCOPY NUMBER)
2125: IS
2126: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';
2127: lv_hdr_ter VARCHAR2(3) := 'N';
2668: FROM okc_rule_groups_b rgp,
2669: okc_rules_b rul1,
2670: okc_rules_b rul2,
2671: okc_k_lines_b cle,
2672: okl_k_lines kle,
2673: okc_line_styles_b lse
2674: WHERE rul2.dnz_chr_id = p_chr_id
2675: AND rul2.rule_information_category = 'LASLL'
2676: AND rgp.RGD_CODE = 'LALEVL'
3916: kle.orig_system_id1,
3917: kle.initial_direct_cost,
3918: tl.item_description,
3919: tl.name
3920: FROM okl_k_lines_full_v kle,
3921: okc_line_styles_b lse,
3922: okc_k_lines_tl tl,
3923: okc_statuses_b sts
3924: WHERE kle.lse_id = lse.id
5546: okc_k_lines_b cle_fin,
5547: okc_line_styles_b lse_fin,
5548: okc_k_lines_b cle,
5549: okl_k_headers khr,
5550: okl_k_lines kle,
5551: okc_line_styles_b lse
5552: WHERE cle.dnz_chr_id = p_dnz_chr_id
5553: AND cle.dnz_chr_id = khr.id
5554: AND khr.deal_type IN ('LEASEDF','LEASEOP','LEASEST','LOAN')
5783: From okl_strm_elements ele,
5784: okl_streams str,
5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts
5790: Where ele.stm_id = str.id
5791: and str.khr_id = chrId
6420: , FEE_CLE.ID FEE_ID
6421: , LNK_CLE.DATE_TERMINATED
6422: FROM OKC_K_LINES_B LNK_CLE
6423: , OKC_LINE_STYLES_B LNK_LSE
6424: , OKL_K_LINES FEE_KLE
6425: , OKC_K_LINES_B FEE_CLE
6426: , OKC_STATUSES_B STS
6427: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID
6428: AND LNK_CLE.DNZ_CHR_ID = cp_chr_id
7122: okl_sif_rets ret,
7123: okl_stream_interfaces sif,
7124: okl_sif_lines line,
7125: okc_k_lines_b cle,
7126: okl_k_lines kle,
7127: okc_line_styles_b lse,
7128: okl_sif_fees fee
7129: WHERE lev.sir_id = ret.id
7130: AND lev.level_type = 'Payment'
7195: AND str.say_code = 'CURR'
7196: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
7197: AND (NVL( str.kle_id, -1) = -1 OR
7198: str.kle_id IN (SELECT kle.id
7199: FROM okl_k_lines_full_v kle,
7200: okc_line_styles_b lse,
7201: okc_statuses_b sts
7202: WHERE KLE.LSE_ID = LSE.ID
7203: AND kle.dnz_chr_id = p_chr_id
8103: --End of bug#3121708 modification BAKUCHIB
8104: -- Get all valid fee lines
8105: CURSOR l_fee_type_csr ( chrId NUMBER, feeId NUMBER ) IS
8106: SELECT kle.fee_type
8107: FROM okl_k_lines kle,
8108: okc_k_lines_b cle,
8109: okc_line_styles_b lse,
8110: okc_statuses_b sts
8111: WHERE cle.lse_id = lse.id
8123: IS
8124: SELECT cle.id fin_id
8125: FROM okc_k_lines_b cle,
8126: okc_line_styles_b lse,
8127: okl_k_lines kle,
8128: okc_statuses_b sts
8129: WHERE cle.dnz_chr_id = chrId
8130: AND cle.lse_id = lse.id
8131: AND lse.lty_code = 'FEE'
8139: IS
8140: SELECT cle.id fin_id
8141: FROM okc_k_lines_b cle,
8142: okc_line_styles_b lse,
8143: okl_k_lines kle,
8144: okc_statuses_b sts
8145: WHERE cle.dnz_chr_id = chrId
8146: AND cle.lse_id = lse.id
8147: AND lse.lty_code = 'FEE'
8153: CURSOR l_link_rollover_csr(cleId NUMBER)
8154: IS
8155: SELECT okc.id kle_id
8156: FROM okc_k_lines_b okc,
8157: okl_k_lines kle ,
8158: okc_line_styles_b lse
8159: WHERE okc.cle_id = cleId
8160: AND okc.lse_id = lse.id
8161: AND okc.id = kle.id
8171: cle.id
8172: FROM okl_sgn_translations sgn,
8173: okl_strm_type_b sty,
8174: okl_subsidies_v sub,
8175: okl_k_lines kle,
8176: okc_statuses_b sts,
8177: okc_line_styles_b lse,
8178: okc_k_lines_b cle
8179: WHERE cle.dnz_chr_id = p_dnz_chr_id
8193: cle.id
8194: --srsreeni Bug5699923 Start
8195: ,sts.ste_code
8196: --srsreeni Bug5699923 End
8197: FROM okl_k_lines kle,
8198: okc_k_lines_b cle,
8199: okl_subsidies_v sub,
8200: okc_statuses_b sts,
8201: okc_line_styles_b lse
8659: kle.fee_type,
8660: kle.initial_direct_cost,
8661: tl.item_description,
8662: tl.name
8663: from okl_k_lines_full_v kle,
8664: okc_line_styles_b lse,
8665: okc_k_lines_tl tl,
8666: okc_statuses_b sts
8667: where KLE.LSE_ID = LSE.ID
8685: kle.id line_id,
8686: stl.id styp_id
8687: FROM OKL_STRM_TMPT_LINES_UV stl,
8688: okc_k_items cim,
8689: okl_k_lines_full_v kle,
8690: okc_line_styles_b ls
8691: WHERE cim.cle_id = kle.id
8692: AND ls.id = kle.lse_id
8693: AND ls.lty_code = 'FEE'
8885: lv_acc_mtd_code okl_subsidies_b.accounting_method_code%TYPE := NULL;
8886: lv_strm_desc VARCHAR2(200);
8887: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
8888: ln_dummy NUMBER := 0;
8889: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
8890: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
8891: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
8892: l_asbv_tbl asbv_tbl_type;
8893: l_sty_id NUMBER;
8886: lv_strm_desc VARCHAR2(200);
8887: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
8888: ln_dummy NUMBER := 0;
8889: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
8890: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
8891: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
8892: l_asbv_tbl asbv_tbl_type;
8893: l_sty_id NUMBER;
8894: l_dep_sty_id NUMBER;
8887: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
8888: ln_dummy NUMBER := 0;
8889: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
8890: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
8891: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
8892: l_asbv_tbl asbv_tbl_type;
8893: l_sty_id NUMBER;
8894: l_dep_sty_id NUMBER;
8895: l_return_status VARCHAR2(1);
8898: IS
8899: SELECT cle.id,
8900: NVL(kle.date_funding,cle.start_date) date_funding
8901: FROM okc_k_lines_b cle,
8902: okl_k_lines kle,
8903: okc_line_styles_b lse
8904: WHERE cle.dnz_chr_id = p_chr_id
8905: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED')
8906: AND cle.id = kle.id
8906: AND cle.id = kle.id
8907: AND cle.lse_id = lse.id
8908: AND lse.lty_code = 'FREE_FORM1';
8909: -- get the accouting method to send only Amoritized Subsidy lines
8910: CURSOR get_acc_mth_code (p_line_id OKL_K_LINES.ID%TYPE)
8911: IS
8912: SELECT subb.accounting_method_code,
8913: cle.id
8914: FROM okl_subsidies_b subb,
8914: FROM okl_subsidies_b subb,
8915: okc_k_lines_b cle_fin,
8916: okc_line_styles_b lse_fin,
8917: okc_k_lines_b cle,
8918: okl_k_lines kle,
8919: okc_line_styles_b lse
8920: WHERE cle.cle_id = p_line_id
8921: AND cle.id = kle.id
8922: AND cle.lse_id = lse.id
8934: FROM okl_subsidies_b subb,
8935: okc_k_lines_b cle_fin,
8936: okc_line_styles_b lse_fin,
8937: okc_k_lines_b cle,
8938: okl_k_lines kle,
8939: okc_line_styles_b lse
8940: WHERE cle.dnz_chr_id = p_dnz_chr_id
8941: AND cle.cle_id = cle_fin.id
8942: AND cle.dnz_chr_id = cle_fin.dnz_chr_id
8953: p_sub_cle_id IN okc_k_lines_b.id%TYPE)
8954: IS
8955:
8956: SELECT kle.sty_id
8957: FROM okl_k_lines kle,
8958: okc_k_lines_b cle,
8959: okc_line_styles_b lse,
8960: okl_subsidies_v sub
8961:
8970: FROM okl_sgn_translations sgn,
8971: okl_strm_type_b sty_inc,
8972: okl_strm_type_b sty,
8973: okl_subsidies_v sub,
8974: okl_k_lines kle,
8975: okc_line_styles_b lse,
8976: okc_k_lines_b cle
8977: WHERE cle.dnz_chr_id = p_dnz_chr_id
8978: AND cle.id = p_sub_cle_id
9409: l_sty_id strm_rec_type;
9410: l_pricing_name VARCHAR2(40);
9411:
9412: l_passthru_percent NUMBER := 0;
9413: l_fee_type apps.OKL_K_LINES.FEE_TYPE%TYPE;
9414:
9415: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE
9416: --INDEX BY BINARY_INTEGER;
9417: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
9450: kle.tradein_amount,
9451: kle.date_funding_expected,
9452: kle.capital_reduction,
9453: kle.capitalize_down_payment_yn
9454: FROM okl_k_lines_full_v kle,
9455: okc_line_styles_b lse,
9456: okc_k_lines_tl tl,
9457: okc_statuses_b sts
9458: WHERE kle.lse_id = lse.id
9503: -- srsreeni - Bug#5699923 - Added - Start
9504: , sts.ste_code
9505: -- srsreeni - Bug#5699923 - Added - End
9506: FROM okc_k_lines_b okc,
9507: okl_k_lines kle ,
9508: okc_line_styles_b lse
9509: ,okc_statuses_b sts
9510: WHERE okc.cle_id = cleId
9511: AND okc.lse_id = lse.id
9525: styt.id sty_id
9526: FROM okl_strm_type_tl styt,
9527: okc_k_items cim,
9528: okc_k_lines_b cle,
9529: okl_k_lines kle
9530: WHERE cle.dnz_chr_id = p_chr_d
9531: AND cle.id = p_cle_id
9532: AND cle.id = kle.id
9533: AND cim.dnz_chr_id = cle.dnz_chr_id
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;
13231: --Added by kthiruva for the VR build
13232: l_ppd_assigned VARCHAR2(1) := 'N';
13233: l_rent_sty_id strm_rec_type;
13234: l_prev_ppd NUMBER := 0;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;
15306: --Added by kthiruva for the VR build
15307: l_rent_sty_id strm_rec_type;
15308: l_prev_ppd NUMBER := 0;
15309:
17488: l_book_type_code Varchar2(15);
17489: l_select Varchar2(2000);
17490: l_msg_index_out Number;
17491: lv_diff_date VARCHAR2(3) := 'N';
17492: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17489: l_select Varchar2(2000);
17490: l_msg_index_out Number;
17491: lv_diff_date VARCHAR2(3) := 'N';
17492: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17490: l_msg_index_out Number;
17491: lv_diff_date VARCHAR2(3) := 'N';
17492: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17498: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
17491: lv_diff_date VARCHAR2(3) := 'N';
17492: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17498: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
17499: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
17492: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17498: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
17499: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
17500: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
17493: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17494: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17495: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17498: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
17499: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
17500: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
17501: lx_no_data_found BOOLEAN;
17506: l_pricing_name VARCHAR2(40);
17507:
17508: l_dependent_sty_id NUMBER;
17509: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
17510: l_sub_amt OKL_K_LINES.AMOUNT%TYPE := 0;
17511: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;
17512:
17513:
17514: -- To check if the chr_id has Financed fee feetype defined
17507:
17508: l_dependent_sty_id NUMBER;
17509: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
17510: l_sub_amt OKL_K_LINES.AMOUNT%TYPE := 0;
17511: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;
17512:
17513:
17514: -- To check if the chr_id has Financed fee feetype defined
17515: CURSOR l_financed_type_csr (chrId NUMBER)
17518: FROM dual
17519: WHERE EXISTS (SELECT 1
17520: FROM okc_k_lines_b cle,
17521: okc_line_styles_b lse,
17522: okl_k_lines kle
17523: WHERE cle.dnz_chr_id = chrId
17524: AND cle.lse_id = lse.id
17525: AND lse.lty_code = 'FEE'
17526: AND cle.id = kle.id
17633: kle.date_funding_expected,
17634: -- Added for Down Payment Enhancement
17635: kle.capital_reduction,
17636: kle.capitalize_down_payment_yn
17637: FROM okl_k_lines_full_v kle,
17638: okc_line_styles_b lse,
17639: okc_k_lines_tl tl,
17640: okc_statuses_b sts
17641: WHERE kle.lse_id = lse.id
17652: FROM okl_subsidies_b subb,
17653: okc_k_lines_b cle_fin,
17654: okc_line_styles_b lse_fin,
17655: okc_k_lines_b cle_sub,
17656: okl_k_lines kle_sub,
17657: okc_line_styles_b lse_sub
17658: WHERE cle_fin.id = p_cle_id
17659: AND cle_fin.dnz_chr_id = p_chr_id
17660: AND cle_sub.id = kle_sub.id
20784: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
20785: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
20786: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
20787: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
20788: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
20789: -- Messages
20790: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';
20791: G_PAYMENT_GAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_GAP_ERROR';
20792: G_PSTH_PAYMENT_ERROR VARCHAR2(200) := 'OKL_PSTH_PAYMENT_ERROR';
20805: CURSOR c_get_psth_csr(p_khr_id okl_k_headers.id%TYPE)
20806: IS
20807: SELECT cle.id
20808: FROM okc_k_lines_b cle,
20809: okl_k_lines kle,
20810: okc_line_styles_b lse
20811: WHERE cle.dnz_chr_id = p_khr_id
20812: AND cle.lse_id = lse.id
20813: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
20820: IS
20821: SELECT COUNT(*)
20822: FROM okc_rules_b slh,
20823: okc_rule_groups_b rgp,
20824: okl_k_lines kle
20825: WHERE rgp.dnz_chr_id = p_khr_id
20826: AND kle.id = p_kle_id
20827: AND rgp.rgd_code= G_RGD_CODE
20828: AND rgp.id = slh.rgp_id
20842: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
20843:
20844: -- Get all the SLH payment lines for Each Khr_id and Line Id
20845: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,
20846: p_cle_id okl_k_lines.id%TYPE)
20847: IS
20848: SELECT rul.id slh_id
20849: FROM okc_rule_groups_b rgp,
20850: okc_rules_b rul
20855: AND rgp.cle_id = p_cle_id;
20856:
20857: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
20858: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
20859: p_cle_id okl_k_lines.id%TYPE,
20860: p_slh_id okc_rules_b.id%TYPE)
20861: IS
20862: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
20863: /* DECODE(SLL.rule_information7,
21402: kle_rv.oec oec,
21403: cle_so.START_DATE
21404: FROM okc_k_headers_b chr_rv,
21405: okc_line_styles_b lse_rv,
21406: okl_k_lines kle_rv,
21407: okc_k_lines_b cle_rv,
21408: okc_rules_b rul_rv,
21409: okc_rule_groups_b rgp_rv,
21410: okc_line_styles_b lse_so,
21525: kle_rv.residual_percentage residual_percent,
21526: cle_so.start_date
21527: FROM okc_k_headers_b chr_rv,
21528: okc_line_styles_b lse_rv,
21529: okl_k_lines kle_rv,
21530: okc_k_lines_b cle_rv,
21531: okc_rules_b rul_rv,
21532: okc_rule_groups_b rgp_rv,
21533: okc_line_styles_b lse_so,
21851: l_salvage NUMBER;
21852: l_purchase_option VARCHAR2(256);
21853: l_deal_type VARCHAR2(256) := NULL;
21854: l_purchase_option_amount NUMBER;
21855: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
21856: ld_asset_start_date DATE;
21857: l_tot_asset_oec NUMBER := 0;
21858: l_asset_oec NUMBER := 0;
21859: l_cap_fee_amt NUMBER := 0;
21859: l_cap_fee_amt NUMBER := 0;
21860: l_total_lending NUMBER := 0;
21861: l_lending NUMBER := 0;
21862: l_lne_tot_lend NUMBER := 0;
21863: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21864: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21865: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21860: l_total_lending NUMBER := 0;
21861: l_lending NUMBER := 0;
21862: l_lne_tot_lend NUMBER := 0;
21863: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21864: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21865: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21868: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
21861: l_lending NUMBER := 0;
21862: l_lne_tot_lend NUMBER := 0;
21863: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21864: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21865: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21868: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
21869: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
21862: l_lne_tot_lend NUMBER := 0;
21863: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21864: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21865: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21868: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
21869: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
21870: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
21863: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21864: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21865: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21868: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
21869: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
21870: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
21871: -- get the Contract Header info
21948: kle.fee_type,
21949: kle.initial_direct_cost,
21950: tl.item_description,
21951: tl.name
21952: FROM okl_k_lines_full_v kle,
21953: okc_line_styles_b lse,
21954: okc_k_lines_tl tl,
21955: okc_statuses_b sts
21956: WHERE kle.lse_id = lse.id
21983: kle.fee_type,
21984: kle.initial_direct_cost,
21985: tl.item_description,
21986: tl.name
21987: FROM okl_k_lines_full_v kle,
21988: okc_line_styles_b lse,
21989: okc_k_lines_tl tl,
21990: okc_statuses_b sts
21991: WHERE kle.lse_id = lse.id
22136: FROM dual
22137: WHERE EXISTS (SELECT 1
22138: FROM okc_k_lines_b cle,
22139: okc_line_styles_b lse,
22140: okl_k_lines kle
22141: WHERE cle.dnz_chr_id = chrId
22142: AND cle.lse_id = lse.id
22143: AND lse.lty_code = 'FEE'
22144: AND cle.id = kle.id
22154: -- Get Capitalized fees amount for a contract
22155: CURSOR get_cap_fee_amt(p_chr_id okc_k_headers_b.id%TYPE)
22156: IS
22157: SELECT NVL(kle.amount, 0) total_cap_fee
22158: FROM okl_k_lines kle,
22159: okc_k_lines_b cle,
22160: okc_k_items cim,
22161: okl_strm_type_b sty
22162: WHERE cle.dnz_chr_id = p_chr_id