APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKL_ASSET_RETURNS_B

Line 5522: FROM okl_asset_returns_b a

5518:
5519: -- get the floor price
5520: CURSOR l_floor_csr (cp_art_id NUMBER, cp_cle_id NUMBER) IS
5521: SELECT SUM (NVL (a.floor_price, 0)) floor_price
5522: FROM okl_asset_returns_b a
5523: WHERE a.id = cp_art_id
5524: AND a.kle_id = cp_cle_id;
5525:
5526: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'repurchase';

Line 5672: FROM okl_asset_returns_b a

5668:
5669: -- get the floor price
5670: CURSOR l_floor_csr (cp_art_id NUMBER) IS
5671: SELECT SUM (NVL (a.floor_price, 0)) floor_price
5672: FROM okl_asset_returns_b a
5673: WHERE a.id = cp_art_id;
5674:
5675: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'repurchase_temp';
5676: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);