[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,
2239: KLN.trxn_extension_id,
2240: b.line_number top_line_number
2241: From OKC_LINE_STYLES_V c,
2242: OKS_BILL_CONT_LINES a,
2243: OKC_K_LINES_B b,
2244: OKS_K_LINES_B KLN
2245: Where a.btn_id Is Null
2246: And a.amount Is Not Null
2247: And b.id = a.cle_id
2271: KLN.trxn_extension_id,
2272: b.line_number top_line_number
2273: From OKC_LINE_STYLES_V c,
2274: OKS_BCL_PR a,
2275: OKC_K_LINES_B b,
2276: OKS_K_LINES_B KLN
2277: Where a.btn_id is null
2278: And a.amount Is Not Null
2279: And b.id = a.cle_id
2309: b.line_number top_line_number
2310: From
2311: OKC_LINE_STYLES_V c,
2312: OKS_BILL_CONT_LINES a,
2313: OKC_K_LINES_B b,
2314: OKS_K_LINES_B KLN
2315: Where a.btn_id is null
2316: And a.amount Is Not Null
2317: And b.id = a.cle_id
2392: rline.exempt_reason_code,
2393: rline.tax_classification_code
2394: --End fixes of eBtax uptake bug#4756579
2395: FROM OKS_K_LINES_V rline,
2396: OKC_K_LINES_B line
2397: WHERE line.id = p_cle_id
2398: AND rline.cle_id = line.id;
2399:
2400:
2418: b.line_number sub_line_number
2419: From OKS_BILL_SUB_LINES a,
2420: OKS_BILL_CONT_LINES c,
2421: OKS_K_LINES_V rline,
2422: OKC_K_LINES_B b
2423: Where a.bcl_id = id_in
2424: AND c.id = a.bcl_id
2425: AND a.cle_id = b.id
2426: AND rline.cle_id = b.id;
2505: --End fixes of eBTax uptake bug#4756579
2506:
2507: Cursor Cur_lsl_type(id_in IN NUMBER) IS
2508: Select cl.lse_id,lsl.name
2509: From OKC_LINE_STYLES_V lsl, OKC_K_LINES_B cl
2510: Where lsl.id = cl.lse_id
2511: And cl.id = id_in;
2512:
2513: