APPS.OKL_RELEASE_PVT dependencies on OKL_ASSET_RETURNS_B

Line 1438: FROM OKL_ASSET_RETURNS_B

1434: CURSOR c_validate_top_line(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1435: SELECT 1
1436: FROM DUAL
1437: WHERE EXISTS (SELECT '1'
1438: FROM OKL_ASSET_RETURNS_B
1439: WHERE kle_id = p_cle_id
1440: AND ars_code = 'RE_LEASE');
1441:
1442: CURSOR c_validate_asset_number(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)

Line 8446: FROM OKL_ASSET_RETURNS_B asr,

8442: SELECT cle.cle_id finasst_id,
8443: cim.object1_id1 asset_id,
8444: cle_orig.cle_id orig_finasst_id,
8445: asr.id asset_return_id
8446: FROM OKL_ASSET_RETURNS_B asr,
8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,

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

8682: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8683: RAISE Okl_Api.G_EXCEPTION_ERROR;
8684: END IF;
8685:
8686: --code added to update status in OKL_ASSET_RETURNS_B
8687: --after the release asset transaction has been processed
8688: OPEN l_asr_csr(p_chr_id);
8689: LOOP
8690: FETCH l_asr_csr into l_asr_rec;