[Home] [Help]
880: l_lne l_toplne_csr%ROWTYPE;
881: --l_svclne l_topsvclne_csr%ROWTYPE;
882: l_svclne srv_amt_csr%ROWTYPE;
883:
884: amount1 okl_k_lines.AMOUNT%TYPE;
885: amount2 okl_k_lines.AMOUNT%TYPE;
886:
887: i NUMBER;
888:
881: --l_svclne l_topsvclne_csr%ROWTYPE;
882: l_svclne srv_amt_csr%ROWTYPE;
883:
884: amount1 okl_k_lines.AMOUNT%TYPE;
885: amount2 okl_k_lines.AMOUNT%TYPE;
886:
887: i NUMBER;
888:
889: BEGIN
1540: NVL(capitalize_down_payment_yn,'N') capitalize_down_payment_yn,
1541: capital_reduction_percent,
1542: oec,
1543: e.ste_code ste_code -- 5264170
1544: FROM OKL_K_LINES a,
1545: OKC_K_LINES_TL b,
1546: OKC_LINE_STYLES_V C,
1547: OKC_K_LINES_B d,
1548: OKC_STATUSES_B e
1576: l_principal_start_date DATE;
1577: l_principal_periods NUMBER;
1578: l_curr_cle_id NUMBER;
1579: l_tot_principal_payment NUMBER;
1580: l_capital_amount OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1577: l_principal_periods NUMBER;
1578: l_curr_cle_id NUMBER;
1579: l_tot_principal_payment NUMBER;
1580: l_capital_amount OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1578: l_curr_cle_id NUMBER;
1579: l_tot_principal_payment NUMBER;
1580: l_capital_amount OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1586: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
1579: l_tot_principal_payment NUMBER;
1580: l_capital_amount OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1586: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
1587:
1580: l_capital_amount OKL_K_LINES.CAPITAL_AMOUNT%TYPE;
1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1586: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
1587:
1588: line_ind NUMBER;
3297: --2. Check the disb amt not exceed line payment amt --
3298: -- Find out lines for a contract
3299: CURSOR lines_csr(p_chr_id IN NUMBER) IS
3300: SELECT cle.id,cle.name,lse.lty_code
3301: FROM okl_k_lines_full_v cle, okc_line_styles_v lse
3302: WHERE cle.dnz_chr_id = p_chr_id
3303: AND cle.lse_id = lse.id
3304: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3305:
3450: pph.id payment_hdr_id,
3451: pph.passthru_start_date,
3452: pph.passthru_term,
3453: pph.passthru_stream_type_id
3454: FROM okl_k_lines_full_v line,
3455: okc_line_styles_v style,
3456: okc_statuses_v sts,
3457: okl_party_payment_hdr pph
3458: WHERE line.lse_id = style.id
3488: nvl(line.name,line.item_description) name,
3489: line.fee_type,
3490: rule.object1_id1,
3491: style.name line_style
3492: FROM okl_k_lines_full_v line,
3493: okc_line_styles_v style,
3494: okc_statuses_v sts,
3495: okc_rule_groups_b rgp,
3496: okc_rules_b rule
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,
4530: okc_k_items kitem,
5783: l.name,
5784: l.amount,
5785: l.capital_amount,
5786: l.fee_type
5787: FROM okl_k_lines_full_v l,
5788: okc_line_styles_v sty,
5789: okc_statuses_v sts
5790: WHERE l.lse_id = sty.id
5791: AND l.sts_code = sts.code
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'
6154: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6164:
6165: CURSOR l_rq_top_fee_ln_csr1 ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6166: SELECT kle.qte_id
6167: FROM okc_k_lines_b cleb,
6168: okl_k_lines kle
6169: WHERE cleb.dnz_chr_id = chrID
6170: AND kle.ID = cleb.ID
6171: AND kle.fee_type = 'ROLLOVER'
6172: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6180: /* Cursor to get the rollover quote fee sub-lines (applied to assets) for a
6181: given contract. */
6182:
6183: CURSOR l_rq_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6184: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6185: SELECT kle.id, kle.amount, cleb.end_date
6186: FROM okc_k_lines_b cleb,
6187: okl_k_lines kle
6188: WHERE cleb.dnz_chr_id = chrID
6183: CURSOR l_rq_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6184: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6185: SELECT kle.id, kle.amount, cleb.end_date
6186: FROM okc_k_lines_b cleb,
6187: okl_k_lines kle
6188: WHERE cleb.dnz_chr_id = chrID
6189: AND kle.ID = cleb.ID
6190: AND cleb.CLE_ID = feeTopLine
6191: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6209: /* Cursor to get the rollover quote fee top/sub-line payments for a
6210: given contract. */
6211:
6212: CURSOR l_rq_fee_pmt_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6213: feeLine IN OKL_K_LINES.ID%TYPE) IS
6214:
6215: SELECT sll.rule_information2 start_date,
6216: SLL.rule_information3 periods,
6217: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6238: /* Cursor to get the rollover quote fee top/sub-line payments HEADER for a
6239: given contract. */
6240:
6241: CURSOR l_rq_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6242: feeLine IN OKL_K_LINES.ID%TYPE) IS
6243:
6244: SELECT slh.id
6245: FROM okc_rules_b slh,
6246: okc_rule_groups_b rgp,
6254: AND slh.object1_id1 = TO_CHAR(sty.id)
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;
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;
6264: x_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
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;
6264: x_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
6265: x_err_msg VARCHAR2(1000);
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
6627: AND kle.ID = cleb.ID
6634: /* Cursor to get the financed fee sub-lines (applied to assets) for a
6635: given contract. */
6636:
6637: CURSOR l_fn_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6638: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6639: SELECT kle.id, kle.amount, cleb.end_date
6640: ,cleb.start_date -- added for bug 5115701
6641: FROM okc_k_lines_b cleb,
6642: okl_k_lines kle,
6638: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6639: SELECT kle.id, kle.amount, cleb.end_date
6640: ,cleb.start_date -- added for bug 5115701
6641: FROM okc_k_lines_b cleb,
6642: okl_k_lines kle,
6643: okc_statuses_b okcsts
6644: WHERE cleb.dnz_chr_id = chrID
6645: AND kle.ID = cleb.ID
6646: AND cleb.CLE_ID = feeTopLine
6652: /* Cursor to get the financed fee top/sub-line payments for a
6653: given contract. */
6654:
6655: CURSOR l_fn_fee_pmt_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6656: feeLine IN OKL_K_LINES.ID%TYPE) IS
6657:
6658: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,
6659: SLL.rule_information3 periods,
6660: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6681: /* Cursor to get the financed fee top/sub-line payments HEADER for a
6682: given contract. */
6683:
6684: CURSOR l_fn_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6685: feeLine IN OKL_K_LINES.ID%TYPE) IS
6686:
6687: SELECT slh.id
6688: FROM okc_rules_b slh,
6689: okc_rule_groups_b rgp,
6697: AND slh.object1_id1 = TO_CHAR(sty.id)
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:
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;
6707: l_pmt_dup_sub_ln_cnt NUMBER := 0; -- Counter for duplicate payments for a sub-line.
6929:
6930: CURSOR l_k_std_csr ( chrID OKC_K_HEADERS_B.ID%TYPE ) IS
6931: SELECT 1
6932: FROM okc_k_lines_b cleb,
6933: okl_k_lines kle,
6934: okc_k_headers_b khr
6935: WHERE khr.id = chrID
6936: AND cleb.dnz_chr_id = khr.id
6937: AND kle.ID = cleb.ID
7019: SELECT ls.lty_code,
7020: ls.name line_type,
7021: kle.id,
7022: kle.name
7023: FROM OKL_K_LINES_FULL_V kle,
7024: OKC_LINE_STYLES_V ls,
7025: OKC_STATUSES_B sts
7026: WHERE kle.lse_id = ls.id
7027: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')
7389: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
7390:
7391: CURSOR get_line_amt (p_id IN NUMBER) IS
7392: SELECT nvl(capital_amount,0) capital_amount, kle.name name
7393: FROM okl_k_lines_full_v kle
7394: WHERE kle.id = p_id;
7395:
7396: CURSOR get_payment_line_amt (p_rgp_id IN NUMBER, p_chr_id IN NUMBER) IS
7397: select nvl(sum(tot_amt),0)
7421: );
7422:
7423: l_cle_id NUMBER;
7424: l_chr_id NUMBER;
7425: l_capital_amount okl_k_lines.capital_amount%type;
7426: l_ast_name okl_k_lines_full_v.name%type := null;
7427: l_payment_amount okl_k_lines.capital_amount%type;
7428: l_deal_type_yn varchar2(1) := 'N';
7429: BEGIN
7422:
7423: l_cle_id NUMBER;
7424: l_chr_id NUMBER;
7425: l_capital_amount okl_k_lines.capital_amount%type;
7426: l_ast_name okl_k_lines_full_v.name%type := null;
7427: l_payment_amount okl_k_lines.capital_amount%type;
7428: l_deal_type_yn varchar2(1) := 'N';
7429: BEGIN
7430: -- initialize return status
7423: l_cle_id NUMBER;
7424: l_chr_id NUMBER;
7425: l_capital_amount okl_k_lines.capital_amount%type;
7426: l_ast_name okl_k_lines_full_v.name%type := null;
7427: l_payment_amount okl_k_lines.capital_amount%type;
7428: l_deal_type_yn varchar2(1) := 'N';
7429: BEGIN
7430: -- initialize return status
7431: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
7788: kle.oec
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
7836: --Bug# 11738752: Added cursor to include Terminated lines
7837: -- when fetching Tradein amount
7838: CURSOR l_line_tradein_csr IS
7839: SELECT kle.tradein_amount
7840: FROM okl_k_lines kle,
7841: okc_k_lines_b cle,
7842: okc_line_styles_b lse,
7843: okc_statuses_b sts
7844: WHERE cle.id = kle.id
8121: p_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
8122: SELECT line.id,
8123: line.line_number,
8124: line.amount
8125: FROM okl_k_lines_full_v line,
8126: okc_line_styles_v style,
8127: okc_statuses_b sts
8128: WHERE line.lse_id = style.id
8129: AND style.lty_code = p_lty_code
8132: AND line.dnz_chr_id = p_chr_id;
8133:
8134: CURSOR sub_line_amt_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
8135: SELECT SUM(NVL(capital_amount,0))
8136: FROM okl_k_lines_full_v line
8137: WHERE line.cle_id = p_line_id;
8138:
8139: CURSOR txd_csr1 (Kleid NUMBER) IS
8140: SELECT
8237: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
8238: SELECT NVL(kle.name,kle.item_description) name,
8239: kle.id,
8240: ls.name line_style
8241: FROM OKL_K_LINES_FULL_V kle,
8242: OKC_LINE_STYLES_v ls,
8243: OKC_STATUSES_B sts
8244: WHERE kle.lse_id = ls.id
8245: AND ls.lty_code = ltycode
8256: l_oec number;
8257:
8258: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
8259: -- cursor to fecth link line id for top line id
8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts
8258: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
8259: -- cursor to fecth link line id for top line id
8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts
8265: WHERE kle.lse_id = ls.id
8266: AND ls.lty_code = ltycode
8268: AND sts.code = kle.sts_code
8269: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
8270: and kle.cle_id = cleid;
8271:
8272: l_link_cle_id OKL_K_LINES_FULL_V.ID%TYPE;
8273: -- Bug 5216135 : kbbhavsa : 29-May-06 : End
8274:
8275: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
8276: SELECT A.ASST_ADD_BOOK_TYPE_CODE,
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
9385: AND cle.dnz_chr_id = p_chr_id
9583:
9584: CURSOR l_inst_csr( chrId NUMBER ) IS
9585: SELECT inst.object_id1_new
9586: FROM OKL_TXL_ITM_INSTS inst,
9587: OKL_K_LINES_FULL_V kle,
9588: OKC_LINE_STYLES_B lse
9589: WHERE inst.kle_id = kle.id
9590: AND lse.id = kle.lse_id
9591: AND lse.lty_code = 'INST_ITEM'
9595:
9596: CURSOR l_shipto_csr( chrId NUMBER ) IS
9597: SELECT inv.shipping_address_id1
9598: FROM OKL_SUPP_INVOICE_DTLS inv,
9599: OKL_K_LINES_FULL_V kle,
9600: OKC_LINE_STYLES_B lse
9601: WHERE inv.cle_id = kle.id
9602: AND lse.id = kle.lse_id
9603: AND lse.lty_code = 'ITEM'
10645: CURSOR con_le_roll_qt_le_csr(p_contract_id IN NUMBER) IS
10646: SELECT 1 FROM
10647: OKC_K_HEADERS_B chr,
10648: OKL_K_HEADERS khr,
10649: OKL_K_LINES kle,
10650: OKC_K_LINES_B cle,
10651: OKL_TRX_QUOTES_B qte,
10652: OKC_LINE_STYLES_B cls
10653: WHERE cle.id = kle.id
10687: orig_clet.name asset_number
10688: from okc_k_lines_b orig_cleb,
10689: okc_k_lines_tl orig_clet,
10690: okc_k_lines_b cleb,
10691: okl_k_lines kle
10692: where orig_clet.id = orig_cleb.id
10693: and orig_clet.language = userenv('LANG')
10694: and orig_cleb.id = cleb.orig_system_id1
10695: and cleb.chr_id = p_chr_id
11027: SELECT line.id,
11028: NVL(line.capital_amount,0) capital_amount,
11029: line.start_date,
11030: strm.code strm_type
11031: FROM okl_k_lines_full_v line,
11032: okc_k_items item,
11033: okl_strmtyp_source_v strm,
11034: okc_line_styles_v style,
11035: okc_statuses_b sts
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
11054: WHERE line.cle_id = p_cle_id
11055: AND line.sts_code = sts.code
11056: --Bug# 4959361: Include Terminated lines when fetching sub-line amount
11278: kle.residual_code,
11279: kle.residual_grnty_amount,
11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,
11283: OKC_LINE_STYLES_B ls,
11284: OKC_STATUSES_B sts
11285: WHERE kle.lse_id = ls.id
11286: AND ls.lty_code = ltycode
11437:
11438: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11439: SELECT line.id,
11440: line.name
11441: FROM okl_k_lines_full_v line,
11442: okc_line_styles_v style,
11443: okc_statuses_b sts
11444: WHERE line. dnz_chr_id = p_chr_id
11445: AND line.lse_id = style.id
11553: cleb.id subsidy_cle_id,
11554: cleb_asst.start_date asset_start_date,
11555: kle.amount,
11556: kle.subsidy_override_amount
11557: FROM okl_k_lines kle,
11558: okc_k_lines_tl clet,
11559: okc_k_lines_b cleb,
11560: okc_line_styles_b lseb,
11561: okc_k_lines_tl clet_asst,
11602: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
11603: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
11604: lx_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
11605: lx_pool_balance okl_subsidy_pools_b.total_subsidy_amount%TYPE;
11606: lv_subsidy_amount okl_k_lines.subsidy_override_amount%TYPE;
11607: -- sjalasut, added local variables to support logging
11608: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';
11609: l_debug_enabled VARCHAR2(10);
11610: is_debug_statement_on BOOLEAN;
12238:
12239: CURSOR l_financed_csr (p_chr_id NUMBER) IS
12240: SELECT cle.id,
12241: style.name line_type
12242: FROM okl_k_lines kle,
12243: okc_k_lines_b cle,
12244: okc_line_styles_v style
12245: WHERE cle.dnz_chr_id = p_chr_id
12246: AND cle.id = kle.id
13514: okl_txl_assets_b txl,
13515: okc_k_lines_b cleb_fa,
13516: okc_statuses_b sts,
13517: okc_k_lines_b cleb_fin,
13518: okl_k_lines kle_fin
13519: WHERE trx.id = txl.tas_id
13520: AND trx.tsu_code = 'ENTERED'
13521: AND trx.tas_type IN ('CFA','CRB')
13522: AND txl.kle_id = cleb_fa.id
13752: kle_rbk.capital_amount new_capital_amount,
13753: kle_orig.capital_amount orig_capital_amount
13754: FROM okc_k_lines_b cleb_rbk,
13755: okc_k_lines_tl clet_rbk,
13756: okl_k_lines kle_rbk,
13757: okl_k_lines kle_orig,
13758: okc_statuses_b sts
13759: WHERE cleb_rbk.chr_id = p_chr_id
13760: AND cleb_rbk.dnz_chr_id = p_chr_id
13753: kle_orig.capital_amount orig_capital_amount
13754: FROM okc_k_lines_b cleb_rbk,
13755: okc_k_lines_tl clet_rbk,
13756: okl_k_lines kle_rbk,
13757: okl_k_lines kle_orig,
13758: okc_statuses_b sts
13759: WHERE cleb_rbk.chr_id = p_chr_id
13760: AND cleb_rbk.dnz_chr_id = p_chr_id
13761: AND cleb_rbk.lse_id = 33
13773: kle_rbk.amount new_amount,
13774: kle_orig.amount orig_amount
13775: FROM okc_k_lines_b cleb_rbk,
13776: okc_k_lines_tl clet_rbk,
13777: okl_k_lines kle_rbk,
13778: okl_k_lines kle_orig,
13779: okc_statuses_b sts
13780: WHERE cleb_rbk.chr_id = p_chr_id
13781: AND cleb_rbk.dnz_chr_id = p_chr_id
13774: kle_orig.amount orig_amount
13775: FROM okc_k_lines_b cleb_rbk,
13776: okc_k_lines_tl clet_rbk,
13777: okl_k_lines kle_rbk,
13778: okl_k_lines kle_orig,
13779: okc_statuses_b sts
13780: WHERE cleb_rbk.chr_id = p_chr_id
13781: AND cleb_rbk.dnz_chr_id = p_chr_id
13782: AND cleb_rbk.lse_id = 52
13794: kle_sub_rbk.amount new_amount,
13795: kle_sub_orig.amount orig_amount
13796: FROM okc_k_lines_b cleb_rbk,
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13801: okl_k_lines kle_sub_orig,
13802: okc_statuses_b sts
13796: FROM okc_k_lines_b cleb_rbk,
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13801: okl_k_lines kle_sub_orig,
13802: okc_statuses_b sts
13803: WHERE cleb_rbk.chr_id = p_chr_id
13804: AND cleb_rbk.dnz_chr_id = p_chr_id
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13801: okl_k_lines kle_sub_orig,
13802: okc_statuses_b sts
13803: WHERE cleb_rbk.chr_id = p_chr_id
13804: AND cleb_rbk.dnz_chr_id = p_chr_id
13805: AND cleb_rbk.lse_id = 52
13995: clet_rbk.name,
13996: cleb_rbk.start_date
13997: FROM okc_k_lines_b cleb_rbk,
13998: okc_k_lines_tl clet_rbk,
13999: okl_k_lines kle_rbk,
14000: okc_statuses_b sts
14001: WHERE cleb_rbk.chr_id = p_chr_id
14002: AND cleb_rbk.dnz_chr_id = p_chr_id
14003: AND cleb_rbk.lse_id = 52
14014: clet_rbk.name,
14015: cleb_sub_rbk.start_date
14016: FROM okc_k_lines_b cleb_rbk,
14017: okc_k_lines_tl clet_rbk,
14018: okl_k_lines kle_rbk,
14019: okc_k_lines_b cleb_sub_rbk,
14020: okc_statuses_b sts
14021: WHERE cleb_rbk.chr_id = p_chr_id
14022: AND cleb_rbk.dnz_chr_id = p_chr_id
14175: kle.date_delivery_expected,
14176: kle.date_funding_expected
14177: FROM okc_k_lines_b cleb,
14178: okc_k_lines_tl clet,
14179: okl_k_lines kle,
14180: okc_statuses_b sts
14181: WHERE cleb.chr_id = p_chr_id
14182: AND cleb.dnz_chr_id = p_chr_id
14183: AND cleb.lse_id = 33