APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_ASSET_RETURNS_B

Line 891: FROM OKL_ASSET_RETURNS_B asr,

887: SELECT cle.cle_id finasst_id,
888: cim.object1_id1 asset_id,
889: cle_orig.cle_id orig_finasst_id,
890: asr.id asset_return_id
891: FROM OKL_ASSET_RETURNS_B asr,
892: OKC_K_LINES_B cle_orig,
893: OKC_LINE_STYLES_B lse_orig,
894: OKC_K_ITEMS cim_orig,
895: OKC_K_ITEMS cim,

Line 2153: --code added to update status in OKL_ASSET_RETURNS_B

2149: RAISE Okl_Api.G_EXCEPTION_ERROR;
2150: END IF;
2151:
2152: --Bug#2522439 Start
2153: --code added to update status in OKL_ASSET_RETURNS_B
2154: --after the release asset transaction has been processed
2155: OPEN l_asr_csr(p_chrv_id);
2156: LOOP
2157: FETCH l_asr_csr into l_asr_rec;