APPS.OKL_FUNDING_PVT dependencies on OKL_ASSETS_LOV_UV

Line 3335: FROM okl_assets_lov_uv a,

3331: CURSOR c_invalid_fund (p_fund_id NUMBER)
3332: IS
3333: SELECT
3334: nvl(a.ASSET_NUMBER,'X') ASSET_NUMBER, a.CHR_ID, a.CLE_ID, b.ipvs_id
3335: FROM okl_assets_lov_uv a,
3336: okl_trx_ap_invoices_b b
3337: WHERE a.chr_id = b.khr_id
3338: and b.id = p_fund_id;
3339: /*bug#5600694 veramach 29-Jun-2007

Line 3343: FROM okl_assets_lov_uv a,

3339: /*bug#5600694 veramach 29-Jun-2007
3340: commented and changed the cursor as above to improve the performance
3341: SELECT
3342: nvl(a.ASSET_NUMBER,'X')
3343: FROM okl_assets_lov_uv a,
3344: --START:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3345: okl_trx_ap_invoices_b b,
3346: OKL_TXL_AP_INV_LNS_V c
3347: WHERE a.chr_id = c.khr_id

Line 6349: FROM okl_assets_lov_uv a,

6345: a.chr_id,
6346: a.cle_id,
6347: p_vendor_site_id
6348: ) kle_amt
6349: FROM okl_assets_lov_uv a,
6350: okc_k_party_roles_b cpl,
6351: okc_k_lines_b LN,
6352: okx_vendor_sites_v sites
6353: WHERE a.chr_id = p_khr_id

Line 6721: from OKL_ASSETS_LOV_UV A,

6717: --FROM
6718: --(
6719: select a.cle_id,
6720: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6721: from OKL_ASSETS_LOV_UV A,
6722: OKL_TRX_AP_INVOICES_B b
6723: WHERE a.chr_id = b.khr_id
6724: AND b.ID = p_fund_id
6725: and NOT EXISTS

Line 7487: FROM okl_assets_lov_uv kle,

7483: p_khr_id okc_k_headers_b.id%TYPE
7484: ) IS
7485: SELECT kle.cle_id kle_id,
7486: kle_k.down_payment_receiver_code downpymnt_recvr
7487: FROM okl_assets_lov_uv kle,
7488: okl_k_lines kle_k
7489: WHERE kle.cle_id = kle_k.ID
7490: AND kle.chr_id = p_khr_id;
7491: */