eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_LINES

Line 1674: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE

1670: IS
1671: -- cursor to fetch the abosrbed fee line with purpose as RVI
1672: CURSOR rvi_fee_csr IS
1673: SELECT KLE.ID ID
1674: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE
1675: WHERE CLE.CHR_ID = p_chr_id
1676: AND CLE.DNZ_CHR_ID = p_chr_id
1677: AND CLE.ID = KLE.ID
1678: AND CLE.LSE_ID = LSE.ID

Line 2102: p_line_id IN okl_k_lines_v.id%TYPE,

2098: x_msg_count OUT NOCOPY NUMBER,
2099: x_msg_data OUT NOCOPY VARCHAR2,
2100: p_formula_name IN okl_formulae_v.name%TYPE,
2101: p_contract_id IN okl_k_headers_v.id%TYPE,
2102: p_line_id IN okl_k_lines_v.id%TYPE,
2103: x_value OUT NOCOPY NUMBER)
2104: IS
2105: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';
2106: lv_hdr_ter VARCHAR2(3) := 'N';

Line 3088: okl_k_lines kle,

3084: FROM okc_rule_groups_b rgp,
3085: okc_rules_b rul1,
3086: okc_rules_b rul2,
3087: okc_k_lines_b cle,
3088: okl_k_lines kle,
3089: okc_line_styles_b lse
3090: WHERE rul2.dnz_chr_id = p_chr_id
3091: AND rul2.rule_information_category = 'LASLL'
3092: AND rgp.RGD_CODE = 'LALEVL'

Line 5019: FROM okl_k_lines_full_v kle,

5015: kle.orig_system_id1,
5016: kle.initial_direct_cost,
5017: tl.item_description,
5018: tl.name
5019: FROM okl_k_lines_full_v kle,
5020: okc_line_styles_b lse,
5021: okc_k_lines_tl tl,
5022: okc_statuses_b sts
5023: WHERE kle.lse_id = lse.id

Line 6660: okl_k_lines kle,

6656: okc_k_lines_b cle_fin,
6657: okc_line_styles_b lse_fin,
6658: okc_k_lines_b cle,
6659: okl_k_headers khr,
6660: okl_k_lines kle,
6661: okc_line_styles_b lse
6662: WHERE cle.dnz_chr_id = p_dnz_chr_id
6663: AND cle.dnz_chr_id = khr.id
6664: AND khr.deal_type IN ('LEASEDF','LEASEOP','LEASEST','LOAN')

Line 7203: okl_k_lines_full_v kle,

7199: From okl_strm_elements ele,
7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts
7206: Where ele.stm_id = str.id
7207: and str.khr_id = chrId

Line 7861: , OKL_K_LINES FEE_KLE

7857: , FEE_CLE.ID FEE_ID
7858: , LNK_CLE.DATE_TERMINATED
7859: FROM OKC_K_LINES_B LNK_CLE
7860: , OKC_LINE_STYLES_B LNK_LSE
7861: , OKL_K_LINES FEE_KLE
7862: , OKC_K_LINES_B FEE_CLE
7863: , OKC_STATUSES_B STS
7864: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID
7865: AND LNK_CLE.DNZ_CHR_ID = cp_chr_id

Line 8620: okl_k_lines kle,

8616: okl_sif_rets ret,
8617: okl_stream_interfaces sif,
8618: okl_sif_lines line,
8619: okc_k_lines_b cle,
8620: okl_k_lines kle,
8621: okc_line_styles_b lse,
8622: okl_sif_fees fee
8623: WHERE lev.sir_id = ret.id
8624: AND lev.level_type = 'Payment'

Line 8693: FROM okl_k_lines_full_v kle,

8689: AND str.say_code = 'CURR'
8690: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
8691: AND (NVL( str.kle_id, -1) = -1 OR
8692: str.kle_id IN (SELECT kle.id
8693: FROM okl_k_lines_full_v kle,
8694: okc_line_styles_b lse,
8695: okc_statuses_b sts
8696: WHERE KLE.LSE_ID = LSE.ID
8697: AND kle.dnz_chr_id = p_chr_id

Line 9627: FROM okl_k_lines kle,

9623: --End of bug#3121708 modification BAKUCHIB
9624: -- Get all valid fee lines
9625: CURSOR l_fee_type_csr ( chrId NUMBER, feeId NUMBER ) IS
9626: SELECT kle.fee_type
9627: FROM okl_k_lines kle,
9628: okc_k_lines_b cle,
9629: okc_line_styles_b lse,
9630: okc_statuses_b sts
9631: WHERE cle.lse_id = lse.id

Line 9647: okl_k_lines kle,

9643: IS
9644: SELECT cle.id fin_id
9645: FROM okc_k_lines_b cle,
9646: okc_line_styles_b lse,
9647: okl_k_lines kle,
9648: okc_statuses_b sts
9649: WHERE cle.dnz_chr_id = chrId
9650: AND cle.lse_id = lse.id
9651: AND lse.lty_code = 'FEE'

Line 9663: okl_k_lines kle,

9659: IS
9660: SELECT cle.id fin_id
9661: FROM okc_k_lines_b cle,
9662: okc_line_styles_b lse,
9663: okl_k_lines kle,
9664: okc_statuses_b sts
9665: WHERE cle.dnz_chr_id = chrId
9666: AND cle.lse_id = lse.id
9667: AND lse.lty_code = 'FEE'

Line 9677: okl_k_lines kle ,

9673: CURSOR l_link_rollover_csr(cleId NUMBER)
9674: IS
9675: SELECT okc.id kle_id
9676: FROM okc_k_lines_b okc,
9677: okl_k_lines kle ,
9678: okc_line_styles_b lse
9679: WHERE okc.cle_id = cleId
9680: AND okc.lse_id = lse.id
9681: AND okc.id = kle.id

Line 9695: okl_k_lines kle,

9691: cle.id
9692: FROM okl_sgn_translations sgn,
9693: okl_strm_type_b sty,
9694: okl_subsidies_v sub,
9695: okl_k_lines kle,
9696: okc_statuses_b sts,
9697: okc_line_styles_b lse,
9698: okc_k_lines_b cle
9699: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 9717: FROM okl_k_lines kle,

9713: cle.id
9714: --srsreeni Bug5699923 Start
9715: ,sts.ste_code
9716: --srsreeni Bug5699923 End
9717: FROM okl_k_lines kle,
9718: okc_k_lines_b cle,
9719: okl_subsidies_v sub,
9720: okc_statuses_b sts,
9721: okc_line_styles_b lse

Line 10185: from okl_k_lines_full_v kle,

10181: kle.initial_direct_cost,
10182: tl.item_description,
10183: tl.name ,
10184: kle.orig_contract_line_id --sechawla 15-jul-09 PRB ESG Enhancements : added orig_contract_line_id
10185: from okl_k_lines_full_v kle,
10186: okc_line_styles_b lse,
10187: okc_k_lines_tl tl,
10188: okc_statuses_b sts
10189: where KLE.LSE_ID = LSE.ID

Line 10211: okl_k_lines_full_v kle,

10207: kle.id line_id,
10208: stl.id styp_id
10209: FROM OKL_STRM_TMPT_LINES_UV stl,
10210: okc_k_items cim,
10211: okl_k_lines_full_v kle,
10212: okc_line_styles_b ls
10213: WHERE cim.cle_id = kle.id
10214: AND ls.id = kle.lse_id
10215: AND ls.lty_code = 'FEE'

Line 10430: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;

10426: lv_acc_mtd_code okl_subsidies_b.accounting_method_code%TYPE := NULL;
10427: lv_strm_desc VARCHAR2(200);
10428: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
10429: ln_dummy NUMBER := 0;
10430: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
10431: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
10432: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
10433: l_asbv_tbl asbv_tbl_type;
10434: l_sty_id NUMBER;

Line 10431: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;

10427: lv_strm_desc VARCHAR2(200);
10428: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
10429: ln_dummy NUMBER := 0;
10430: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
10431: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
10432: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
10433: l_asbv_tbl asbv_tbl_type;
10434: l_sty_id NUMBER;
10435: l_dep_sty_id NUMBER;

Line 10432: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;

10428: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
10429: ln_dummy NUMBER := 0;
10430: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;
10431: ln_cap_amt okl_k_lines.capital_amount%TYPE := 0;
10432: ln_cap_dis okl_k_lines.capital_amount%TYPE := 0;
10433: l_asbv_tbl asbv_tbl_type;
10434: l_sty_id NUMBER;
10435: l_dep_sty_id NUMBER;
10436: l_return_status VARCHAR2(1);

Line 10444: okl_k_lines kle,

10440: SELECT cle.id,
10441: NVL(kle.date_funding,cle.start_date) date_funding ,
10442: kle.orig_contract_line_id --sechawla 15-jun-09 PRB ESG Enhancement : added orig_contract_line_id
10443: FROM okc_k_lines_b cle,
10444: okl_k_lines kle,
10445: okc_line_styles_b lse
10446: WHERE cle.dnz_chr_id = p_chr_id
10447: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED')
10448: AND cle.id = kle.id

Line 10454: CURSOR get_acc_mth_code (p_line_id OKL_K_LINES.ID%TYPE)

10450: AND lse.lty_code = 'FREE_FORM1';
10451: -- get the accouting method to send only Amoritized Subsidy lines
10452: --Modified bug 9306619 to not pick ABANDONED subsidy lines
10453: -- get the accouting method to send only Amoritized Subsidy lines
10454: CURSOR get_acc_mth_code (p_line_id OKL_K_LINES.ID%TYPE)
10455: IS
10456: SELECT subb.accounting_method_code,
10457: cle.id
10458: FROM okl_subsidies_b subb,

Line 10462: okl_k_lines kle,

10458: FROM okl_subsidies_b subb,
10459: okc_k_lines_b cle_fin,
10460: okc_line_styles_b lse_fin,
10461: okc_k_lines_b cle,
10462: okl_k_lines kle,
10463: okc_line_styles_b lse
10464: WHERE cle.cle_id = p_line_id
10465: AND cle.id = kle.id
10466: AND cle.lse_id = lse.id

Line 10483: okl_k_lines kle,

10479: FROM okl_subsidies_b subb,
10480: okc_k_lines_b cle_fin,
10481: okc_line_styles_b lse_fin,
10482: okc_k_lines_b cle,
10483: okl_k_lines kle,
10484: okc_line_styles_b lse
10485: WHERE cle.dnz_chr_id = p_dnz_chr_id
10486: AND cle.cle_id = cle_fin.id
10487: AND cle.dnz_chr_id = cle_fin.dnz_chr_id

Line 10502: FROM okl_k_lines kle,

10498: p_sub_cle_id IN okc_k_lines_b.id%TYPE)
10499: IS
10500:
10501: SELECT kle.sty_id
10502: FROM okl_k_lines kle,
10503: okc_k_lines_b cle,
10504: okc_line_styles_b lse,
10505: okl_subsidies_v sub
10506:

Line 10519: okl_k_lines kle,

10515: FROM okl_sgn_translations sgn,
10516: okl_strm_type_b sty_inc,
10517: okl_strm_type_b sty,
10518: okl_subsidies_v sub,
10519: okl_k_lines kle,
10520: okc_line_styles_b lse,
10521: okc_k_lines_b cle
10522: WHERE cle.dnz_chr_id = p_dnz_chr_id
10523: AND cle.id = p_sub_cle_id

Line 10998: l_fee_type apps.OKL_K_LINES.FEE_TYPE%TYPE;

10994:
10995: l_pricing_name VARCHAR2(150); --02-Sep-11 SECHAWLA 12936702
10996:
10997: l_passthru_percent NUMBER := 0;
10998: l_fee_type apps.OKL_K_LINES.FEE_TYPE%TYPE;
10999:
11000: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE
11001: --INDEX BY BINARY_INTEGER;
11002: l_strm_type_id_tbl okl_strm_type_id_tbl_type;

Line 11040: FROM okl_k_lines_full_v kle,

11036: kle.date_funding_expected,
11037: kle.capital_reduction,
11038: kle.capitalize_down_payment_yn,
11039: kle.orig_contract_line_id --sechawla 15-jul-09 ESG PRB Enhancements : added orig_contract_line_id
11040: FROM okl_k_lines_full_v kle,
11041: okc_line_styles_b lse,
11042: okc_k_lines_tl tl,
11043: okc_statuses_b sts
11044: WHERE kle.lse_id = lse.id

Line 11095: okl_k_lines kle ,

11091: -- srsreeni - Bug#5699923 - Added - End
11092: , kle.orig_contract_line_id ,--sechawla 15-jul-09 PRB ESG enhancements : added orig_contract_line_id
11093: okc.start_date --11-Sep-09 sechawla 8798556 : added
11094: FROM okc_k_lines_b okc,
11095: okl_k_lines kle ,
11096: okc_line_styles_b lse
11097: ,okc_statuses_b sts
11098: WHERE okc.cle_id = cleId
11099: AND okc.lse_id = lse.id

Line 11117: okl_k_lines kle

11113: styt.id sty_id
11114: FROM okl_strm_type_tl styt,
11115: okc_k_items cim,
11116: okc_k_lines_b cle,
11117: okl_k_lines kle
11118: WHERE cle.dnz_chr_id = p_chr_d
11119: AND cle.id = p_cle_id
11120: AND cle.id = kle.id
11121: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 15333: l_total_oec okl_k_lines_full_v.oec%TYPE;

15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;
15334: --Added by kthiruva for the VR build
15335: l_ppd_assigned VARCHAR2(1) := 'N';
15336: l_rent_sty_id strm_rec_type;
15337: l_prev_ppd NUMBER := 0;

Line 17618: l_total_oec okl_k_lines_full_v.oec%TYPE;

17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;
17619: --Added by kthiruva for the VR build
17620: l_rent_sty_id strm_rec_type;
17621: l_prev_ppd NUMBER := 0;
17622:

Line 20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20097: l_book_type_code Varchar2(15);
20098: l_select Varchar2(2000);
20099: l_msg_index_out Number;
20100: lv_diff_date VARCHAR2(3) := 'N';
20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

Line 20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20098: l_select Varchar2(2000);
20099: l_msg_index_out Number;
20100: lv_diff_date VARCHAR2(3) := 'N';
20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

Line 20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20099: l_msg_index_out Number;
20100: lv_diff_date VARCHAR2(3) := 'N';
20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;

Line 20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20100: lv_diff_date VARCHAR2(3) := 'N';
20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;

Line 20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20101: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
20109: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;

Line 20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

20102: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20103: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
20109: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
20110: lx_no_data_found BOOLEAN;

Line 20120: l_sub_amt OKL_K_LINES.AMOUNT%TYPE := 0;

20116: l_pricing_name VARCHAR2(150); --02-Sep-11 SECHAWLA 12936702
20117:
20118: l_dependent_sty_id NUMBER;
20119: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
20120: l_sub_amt OKL_K_LINES.AMOUNT%TYPE := 0;
20121: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;
20122: l_down_payment_amt NUMBER; --Added by bkatraga for bug 15942693
20123:
20124: --Added by bkatraga for bug 14822974

Line 20121: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;

20117:
20118: l_dependent_sty_id NUMBER;
20119: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
20120: l_sub_amt OKL_K_LINES.AMOUNT%TYPE := 0;
20121: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;
20122: l_down_payment_amt NUMBER; --Added by bkatraga for bug 15942693
20123:
20124: --Added by bkatraga for bug 14822974
20125: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%TYPE;

Line 20156: okl_k_lines kle

20152: FROM dual
20153: WHERE EXISTS (SELECT 1
20154: FROM okc_k_lines_b cle,
20155: okc_line_styles_b lse,
20156: okl_k_lines kle
20157: WHERE cle.dnz_chr_id = chrId
20158: AND cle.lse_id = lse.id
20159: AND lse.lty_code = 'FEE'
20160: AND cle.id = kle.id

Line 20275: FROM okl_k_lines_full_v kle,

20271: kle.capital_reduction,
20272: kle.capitalize_down_payment_yn,
20273: kle.orig_contract_line_id, --sechawla 10-jul-09 PRB ESG enhancements : added
20274: kle.capital_reduction_percent
20275: FROM okl_k_lines_full_v kle,
20276: okc_line_styles_b lse,
20277: okc_k_lines_tl tl,
20278: okc_statuses_b sts
20279: WHERE kle.lse_id = lse.id

Line 20294: okl_k_lines kle_sub,

20290: FROM okl_subsidies_b subb,
20291: okc_k_lines_b cle_fin,
20292: okc_line_styles_b lse_fin,
20293: okc_k_lines_b cle_sub,
20294: okl_k_lines kle_sub,
20295: okc_line_styles_b lse_sub
20296: WHERE cle_fin.id = p_cle_id
20297: AND cle_fin.dnz_chr_id = p_chr_id
20298: AND cle_sub.id = kle_sub.id

Line 23624: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';

23620: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
23621: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
23622: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
23623: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
23624: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
23625: -- Messages
23626: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';
23627: G_PAYMENT_GAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_GAP_ERROR';
23628: G_PSTH_PAYMENT_ERROR VARCHAR2(200) := 'OKL_PSTH_PAYMENT_ERROR';

Line 23645: okl_k_lines kle,

23641: CURSOR c_get_psth_csr(p_khr_id okl_k_headers.id%TYPE)
23642: IS
23643: SELECT cle.id
23644: FROM okc_k_lines_b cle,
23645: okl_k_lines kle,
23646: okc_line_styles_b lse
23647: WHERE cle.dnz_chr_id = p_khr_id
23648: AND cle.lse_id = lse.id
23649: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')

Line 23660: okl_k_lines kle

23656: IS
23657: SELECT COUNT(*)
23658: FROM okc_rules_b slh,
23659: okc_rule_groups_b rgp,
23660: okl_k_lines kle
23661: WHERE rgp.dnz_chr_id = p_khr_id
23662: AND kle.id = p_kle_id
23663: AND rgp.rgd_code= G_RGD_CODE
23664: AND rgp.id = slh.rgp_id

Line 23682: p_cle_id okl_k_lines.id%TYPE)

23678: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
23679:
23680: -- Get all the SLH payment lines for Each Khr_id and Line Id
23681: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23682: p_cle_id okl_k_lines.id%TYPE)
23683: IS
23684: SELECT rul.id slh_id
23685: FROM okc_rule_groups_b rgp,
23686: okc_rules_b rul

Line 23695: p_cle_id okl_k_lines.id%TYPE,

23691: AND rgp.cle_id = p_cle_id;
23692:
23693: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
23694: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23695: p_cle_id okl_k_lines.id%TYPE,
23696: p_slh_id okc_rules_b.id%TYPE)
23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,

Line 24249: okl_k_lines kle_rv,

24245: kle_rv.oec oec,
24246: cle_so.START_DATE
24247: FROM okc_k_headers_b chr_rv,
24248: okc_line_styles_b lse_rv,
24249: okl_k_lines kle_rv,
24250: okc_k_lines_b cle_rv,
24251: okc_rules_b rul_rv,
24252: okc_rule_groups_b rgp_rv,
24253: okc_line_styles_b lse_so,

Line 24372: okl_k_lines kle_rv,

24368: kle_rv.residual_percentage residual_percent,
24369: cle_so.start_date
24370: FROM okc_k_headers_b chr_rv,
24371: okc_line_styles_b lse_rv,
24372: okl_k_lines kle_rv,
24373: okc_k_lines_b cle_rv,
24374: okc_rules_b rul_rv,
24375: okc_rule_groups_b rgp_rv,
24376: okc_line_styles_b lse_so,

Line 24698: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE;

24694: l_salvage NUMBER;
24695: l_purchase_option VARCHAR2(256);
24696: l_deal_type VARCHAR2(256) := NULL;
24697: l_purchase_option_amount NUMBER;
24698: l_value OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
24699: ld_asset_start_date DATE;
24700: l_tot_asset_oec NUMBER := 0;
24701: l_asset_oec NUMBER := 0;
24702: l_cap_fee_amt NUMBER := 0;

Line 24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

24702: l_cap_fee_amt NUMBER := 0;
24703: l_total_lending NUMBER := 0;
24704: l_lending NUMBER := 0;
24705: l_lne_tot_lend NUMBER := 0;
24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

Line 24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

24703: l_total_lending NUMBER := 0;
24704: l_lending NUMBER := 0;
24705: l_lne_tot_lend NUMBER := 0;
24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;

Line 24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

24704: l_lending NUMBER := 0;
24705: l_lne_tot_lend NUMBER := 0;
24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;

Line 24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

24705: l_lne_tot_lend NUMBER := 0;
24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
24713: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;

Line 24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;

24706: l_tradein OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24707: l_capreduc OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
24713: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
24714: -- get the Contract Header info

Line 24795: FROM okl_k_lines_full_v kle,

24791: kle.fee_type,
24792: kle.initial_direct_cost,
24793: tl.item_description,
24794: tl.name
24795: FROM okl_k_lines_full_v kle,
24796: okc_line_styles_b lse,
24797: okc_k_lines_tl tl,
24798: okc_statuses_b sts
24799: WHERE kle.lse_id = lse.id

Line 24830: FROM okl_k_lines_full_v kle,

24826: kle.fee_type,
24827: kle.initial_direct_cost,
24828: tl.item_description,
24829: tl.name
24830: FROM okl_k_lines_full_v kle,
24831: okc_line_styles_b lse,
24832: okc_k_lines_tl tl,
24833: okc_statuses_b sts
24834: WHERE kle.lse_id = lse.id

Line 24983: okl_k_lines kle

24979: FROM dual
24980: WHERE EXISTS (SELECT 1
24981: FROM okc_k_lines_b cle,
24982: okc_line_styles_b lse,
24983: okl_k_lines kle
24984: WHERE cle.dnz_chr_id = chrId
24985: AND cle.lse_id = lse.id
24986: AND lse.lty_code = 'FEE'
24987: AND cle.id = kle.id

Line 25001: FROM okl_k_lines kle,

24997: -- Get Capitalized fees amount for a contract
24998: CURSOR get_cap_fee_amt(p_chr_id okc_k_headers_b.id%TYPE)
24999: IS
25000: SELECT NVL(kle.amount, 0) total_cap_fee
25001: FROM okl_k_lines kle,
25002: okc_k_lines_b cle,
25003: okc_k_items cim,
25004: okl_strm_type_b sty
25005: WHERE cle.dnz_chr_id = p_chr_id