DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on OKS_K_LINES_B

Line 2244: OKS_K_LINES_B KLN

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

Line 2276: OKS_K_LINES_B KLN

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

Line 2314: OKS_K_LINES_B KLN

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

Line 2372: OKS_K_LINES_B line

2368: --End fixes of eBtax uptake bug#4756579
2369: FROM
2370: OKS_K_HEADERS_B rhdr,
2371: OKC_K_HEADERS_B hdr,
2372: OKS_K_LINES_B line
2373: WHERE line.cle_id = p_cle_id
2374: AND hdr.id = line.dnz_chr_id
2375: AND hdr.id = rhdr.chr_id;
2376:

Line 2636: From oks_k_lines_b kln

2632: Where bsd.bsl_id = p_id;
2633:
2634: Cursor l_usage_csr(p_id IN Number,p_hdr_id IN Number) Is
2635: Select usage_type
2636: From oks_k_lines_b kln
2637: Where kln.cle_id = p_id;
2638: --End 27-Dec-2005 nechatur Fix for bug#4390448
2639:
2640: