[Home] [Help]
236: -- x_cust_trx_id OUT NOCOPY NUMBER,
237: -- x_cust_trx_line_id OUT NOCOPY NUMBER
238: )
239: IS
240: Cursor l_get_cov_lvl(p_cle_id IN NUMBER) IS SELECT id from okc_k_lines_b WHERE cle_id = p_cle_id AND lse_id in (18,25); Cursor Cur_billinstance_hdr (p_date_billed_from IN DATE, p_date_billed_to IN DATE,
241: p_id IN NUMBER,
242: p_contract_number IN VARCHAR2,
243: p_con_modifier IN VARCHAR2)IS
244: SELECT c.Customer_trx_line_id,
2257: KLN.trxn_extension_id,
2258: b.line_number top_line_number
2259: From OKC_LINE_STYLES_V c,
2260: OKS_BILL_CONT_LINES a,
2261: OKC_K_LINES_B b,
2262: OKS_K_LINES_B KLN
2263: Where a.btn_id Is Null
2264: And a.amount Is Not Null
2265: And b.id = a.cle_id
2289: KLN.trxn_extension_id,
2290: b.line_number top_line_number
2291: From OKC_LINE_STYLES_V c,
2292: OKS_BCL_PR a,
2293: OKC_K_LINES_B b,
2294: OKS_K_LINES_B KLN
2295: Where a.btn_id is null
2296: And a.amount Is Not Null
2297: And b.id = a.cle_id
2327: b.line_number top_line_number
2328: From
2329: OKC_LINE_STYLES_V c,
2330: OKS_BILL_CONT_LINES a,
2331: OKC_K_LINES_B b,
2332: OKS_K_LINES_B KLN
2333: Where a.btn_id is null
2334: And a.amount Is Not Null
2335: And b.id = a.cle_id
2411: rline.exempt_reason_code,
2412: rline.tax_classification_code
2413: --End fixes of eBtax uptake bug#4756579
2414: FROM OKS_K_LINES_V rline,
2415: OKC_K_LINES_B line
2416: WHERE line.id = p_cle_id
2417: AND rline.cle_id = line.id;
2418:
2419:
2437: b.line_number sub_line_number
2438: From OKS_BILL_SUB_LINES a,
2439: OKS_BILL_CONT_LINES c,
2440: OKS_K_LINES_V rline,
2441: OKC_K_LINES_B b
2442: Where a.bcl_id = id_in
2443: AND c.id = a.bcl_id
2444: AND a.cle_id = b.id
2445: AND rline.cle_id = b.id;
2524: --End fixes of eBTax uptake bug#4756579
2525:
2526: Cursor Cur_lsl_type(id_in IN NUMBER) IS
2527: Select cl.lse_id,lsl.name
2528: From OKC_LINE_STYLES_V lsl, OKC_K_LINES_B cl
2529: Where lsl.id = cl.lse_id
2530: And cl.id = id_in;
2531:
2532: