APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_ASSETS_B

Line 14200: FROM okl_assets_b ast, okl_cost_adjustments_b adj

14196:
14197: --cursor to get capitalized down payment for the asset
14198: CURSOR c_cap_down_pmnt (p_asset_id IN NUMBER) IS
14199: SELECT sum(adj.value) cap_down_payment
14200: FROM okl_assets_b ast, okl_cost_adjustments_b adj
14201: WHERE ast.parent_object_code = 'LEASEQUOTE'
14202: AND adj.parent_object_id = ast.id
14203: AND adj.ADJUSTMENT_SOURCE_TYPE = 'DOWN_PAYMENT'
14204: AND adj.PROCESSING_TYPE = 'CAPITALIZE'

Line 14210: FROM okl_assets_b ast, okl_cost_adjustments_b adj

14206:
14207: --cursor to get trade-in amount for the asset
14208: CURSOR c_tradein_amnt (p_asset_id IN NUMBER) IS
14209: SELECT sum(adj.value) tradeIn_amount
14210: FROM okl_assets_b ast, okl_cost_adjustments_b adj
14211: WHERE ast.parent_object_code = 'LEASEQUOTE'
14212: AND adj.parent_object_id = ast.id
14213: AND adj.adjustment_source_type = 'TRADEIN'
14214: AND ast.id = p_asset_id;