APPS.OKS_ARFEEDER_PUB dependencies on OKS_K_LINES_B

Line 2262: OKS_K_LINES_B KLN

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
2266: And b.id = p_cle_id

Line 2294: OKS_K_LINES_B KLN

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
2298: And b.id = p_cle_id

Line 2332: OKS_K_LINES_B KLN

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
2336: AND b.id = KLN.cle_id

Line 2391: OKS_K_LINES_B line

2387: --End fixes of eBtax uptake bug#4756579
2388: FROM
2389: OKS_K_HEADERS_B rhdr,
2390: OKC_K_HEADERS_B hdr,
2391: OKS_K_LINES_B line
2392: WHERE line.cle_id = p_cle_id
2393: AND hdr.id = line.dnz_chr_id
2394: AND hdr.id = rhdr.chr_id;
2395:

Line 2655: From oks_k_lines_b kln

2651: Where bsd.bsl_id = p_id;
2652:
2653: Cursor l_usage_csr(p_id IN Number,p_hdr_id IN Number) Is
2654: Select usage_type
2655: From oks_k_lines_b kln
2656: Where kln.cle_id = p_id;
2657: --End 27-Dec-2005 nechatur Fix for bug#4390448
2658:
2659:

Line 2682: FROM oks_k_lines_b

2678:
2679: --skuchima added for bug#10260151
2680: CURSOR cur_inv_print_flag(p_id IN number) IS
2681: SELECT inv_print_flag
2682: FROM oks_k_lines_b
2683: WHERE cle_id=p_id;
2684:
2685: l_inv_print_flag VARCHAR2(1);
2686: