APPS.OKL_FUNDING_PVT dependencies on OKL_ASSETS_LOV_UV

Line 3205: FROM okl_assets_lov_uv a,

3201: CURSOR c_invalid_fund (p_fund_id NUMBER)
3202: IS
3203: SELECT
3204: nvl(a.ASSET_NUMBER,'X') ASSET_NUMBER, a.CHR_ID, a.CLE_ID, b.ipvs_id
3205: FROM okl_assets_lov_uv a,
3206: okl_trx_ap_invoices_b b
3207: WHERE a.chr_id = b.khr_id
3208: and b.id = p_fund_id;
3209: /*bug#5600694 veramach 29-Jun-2007

Line 3213: FROM okl_assets_lov_uv a,

3209: /*bug#5600694 veramach 29-Jun-2007
3210: commented and changed the cursor as above to improve the performance
3211: SELECT
3212: nvl(a.ASSET_NUMBER,'X')
3213: FROM okl_assets_lov_uv a,
3214: --START:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3215: okl_trx_ap_invoices_b b,
3216: OKL_TXL_AP_INV_LNS_V c
3217: WHERE a.chr_id = c.khr_id

Line 6192: FROM okl_assets_lov_uv a,

6188: a.chr_id,
6189: a.cle_id,
6190: p_vendor_site_id
6191: ) kle_amt
6192: FROM okl_assets_lov_uv a,
6193: okc_k_party_roles_b cpl,
6194: okc_k_lines_b LN,
6195: okx_vendor_sites_v sites
6196: WHERE a.chr_id = p_khr_id

Line 6564: from OKL_ASSETS_LOV_UV A,

6560: --FROM
6561: --(
6562: select a.cle_id,
6563: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6564: from OKL_ASSETS_LOV_UV A,
6565: OKL_TRX_AP_INVOICES_B b
6566: WHERE a.chr_id = b.khr_id
6567: AND b.ID = p_fund_id
6568: and NOT EXISTS

Line 7274: FROM okl_assets_lov_uv kle,

7270: p_khr_id okc_k_headers_b.id%TYPE
7271: ) IS
7272: SELECT kle.cle_id kle_id,
7273: kle_k.down_payment_receiver_code downpymnt_recvr
7274: FROM okl_assets_lov_uv kle,
7275: okl_k_lines kle_k
7276: WHERE kle.cle_id = kle_k.ID
7277: AND kle.chr_id = p_khr_id;
7278: */