APPS.OKL_RELEASE_PVT dependencies on OKL_ASSET_RETURNS_B

Line 1459: FROM OKL_ASSET_RETURNS_B

1455: CURSOR c_validate_top_line(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1456: SELECT 1
1457: FROM DUAL
1458: WHERE EXISTS (SELECT '1'
1459: FROM OKL_ASSET_RETURNS_B
1460: WHERE kle_id = p_cle_id
1461: AND ars_code = 'RE_LEASE');
1462:
1463: CURSOR c_validate_asset_number(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)

Line 8775: FROM OKL_ASSET_RETURNS_B asr,

8771: SELECT cle.cle_id finasst_id,
8772: cim.object1_id1 asset_id,
8773: cle_orig.cle_id orig_finasst_id,
8774: asr.id asset_return_id
8775: FROM OKL_ASSET_RETURNS_B asr,
8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,

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

9011: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
9012: RAISE Okl_Api.G_EXCEPTION_ERROR;
9013: END IF;
9014:
9015: --code added to update status in OKL_ASSET_RETURNS_B
9016: --after the release asset transaction has been processed
9017: OPEN l_asr_csr(p_chr_id);
9018: LOOP
9019: FETCH l_asr_csr into l_asr_rec;