APPS.OKL_LA_ASSET_PVT dependencies on OKL_K_LINES

Line 169: okl_k_lines sub_kle,

165:
166: cursor l_sub_tot_csr(p_asset_cle_id in number) is
167: select nvl(sum(nvl(sub_kle.subsidy_override_amount,nvl(sub_kle.amount,0))),0)
168: from okl_subsidies_b subb,
169: okl_k_lines sub_kle,
170: okc_k_lines_b sub_cle,
171: okc_line_styles_b sub_lse
172: where subb.id = sub_kle.subsidy_id
173: and subb.accounting_method_code = 'NET'

Line 522: ,okl_k_lines KLE

518: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
519: AND chr.ID = p_chr_id
520: AND exists (SELECT '1'
521: FROM okc_k_lines_b CLEB
522: ,okl_k_lines KLE
523: WHERE CLEB.id = KLE.id
524: AND CLEB.dnz_chr_id = p_chr_id
525: AND CLEB.chr_id = p_chr_id
526: AND CLEB.LSE_ID = 33 --for asset line

Line 530: ,okl_k_lines KLE

526: AND CLEB.LSE_ID = 33 --for asset line
527: AND NVL(KLE.re_lease_yn,'N')= 'Y')
528: AND NOT EXISTS (SELECT '1'
529: FROM okc_k_lines_b CLEB
530: ,okl_k_lines KLE
531: WHERE CLEB.id = KLE.id
532: AND CLEB.dnz_chr_id = p_chr_id
533: AND CLEB.chr_id = p_chr_id
534: AND CLEB.LSE_ID = 33 --for asset line

Line 3042: FROM okl_k_lines kle

3038: --Bug#5495504
3039: CURSOR c_get_tradein_amt
3040: IS
3041: SELECT kle.tradein_amount
3042: FROM okl_k_lines kle
3043: WHERE kle.id = p_top_line_id;
3044:
3045: BEGIN
3046: /*