APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKL_ASSET_RETURNS_B

Line 5641: FROM okl_asset_returns_b a

5637:
5638: -- get the floor price
5639: CURSOR l_floor_csr (cp_art_id NUMBER, cp_cle_id NUMBER) IS
5640: SELECT SUM (NVL (a.floor_price, 0)) floor_price
5641: FROM okl_asset_returns_b a
5642: WHERE a.id = cp_art_id
5643: AND a.kle_id = cp_cle_id;
5644:
5645: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'repurchase';

Line 5791: FROM okl_asset_returns_b a

5787:
5788: -- get the floor price
5789: CURSOR l_floor_csr (cp_art_id NUMBER) IS
5790: SELECT SUM (NVL (a.floor_price, 0)) floor_price
5791: FROM okl_asset_returns_b a
5792: WHERE a.id = cp_art_id;
5793:
5794: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'repurchase_temp';
5795: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);