APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_K_LINES

Line 13272: ,okl_k_lines kle

13268:
13269: CURSOR l_finassets_csr(cp_chr_id IN NUMBER) IS
13270: SELECT cle.id fin_asset_id, cle.name asset_number
13271: FROM okc_k_lines_v cle
13272: ,okl_k_lines kle
13273: WHERE cle.chr_id = cp_chr_id
13274: AND cle.lse_id = 33
13275: AND kle.id = cle.id
13276: AND NVL(kle.re_lease_yn,'N') = 'N'

Line 13305: FROM okl_k_lines kle

13301: AND rulb2.rule_information_category = 'LASLL'
13302: -- Bug #15992711 : Start
13303: -- modification to look at re_lease_yn flag at line level
13304: AND EXISTS ( SELECT '1'
13305: FROM okl_k_lines kle
13306: WHERE NVL(kle.re_lease_yn,'N') = 'N'
13307: AND kle.id = rgpb.cle_id)
13308: -- Bug #15992711 : End
13309: GROUP BY rgpb.cle_id, styb.id, styb.CODE

Line 13340: FROM okl_k_lines kle

13336: AND rulb2.rule_information_category = 'LASLL'
13337: -- Bug #15992711 : Start
13338: -- modification to look at re_lease_yn flag at line level
13339: AND EXISTS ( SELECT '1'
13340: FROM okl_k_lines kle
13341: WHERE NVL(kle.re_lease_yn,'N') = 'N'
13342: AND kle.id = rgpb.cle_id)
13343: -- Bug #15992711 : End
13344: GROUP BY rgpb.cle_id, styb.id, styb.CODE;