APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_ASSETS_B

Line 15432: FROM okl_assets_b ast, okl_cost_adjustments_b adj

15428:
15429: --cursor to get capitalized down payment for the asset
15430: CURSOR c_cap_down_pmnt (p_asset_id IN NUMBER) IS
15431: SELECT sum(adj.value) cap_down_payment
15432: FROM okl_assets_b ast, okl_cost_adjustments_b adj
15433: WHERE ast.parent_object_code = 'LEASEQUOTE'
15434: AND adj.parent_object_id = ast.id
15435: AND adj.ADJUSTMENT_SOURCE_TYPE = 'DOWN_PAYMENT'
15436: AND adj.PROCESSING_TYPE = 'CAPITALIZE'

Line 15442: FROM okl_assets_b ast, okl_cost_adjustments_b adj

15438:
15439: --cursor to get trade-in amount for the asset
15440: CURSOR c_tradein_amnt (p_asset_id IN NUMBER) IS
15441: SELECT sum(adj.value) tradeIn_amount
15442: FROM okl_assets_b ast, okl_cost_adjustments_b adj
15443: WHERE ast.parent_object_code = 'LEASEQUOTE'
15444: AND adj.parent_object_id = ast.id
15445: AND adj.adjustment_source_type = 'TRADEIN'
15446: AND ast.id = p_asset_id;