APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 3019: FROM okl_cost_adjustments_b

3015: SELECT ADJUSTMENT_SOURCE_ID,
3016: VALUE,
3017: SUPPLIER_ID,
3018: default_subsidy_amount
3019: FROM okl_cost_adjustments_b
3020: WHERE PARENT_OBJECT_CODE = 'ASSET'
3021: AND ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
3022: AND PARENT_OBJECT_ID = p_ast_id;
3023: l_cre_asb_tbl OKL_ASSET_SUBSIDY_PVT.asb_tbl_type;

Line 3639: FROM OKL_COST_ADJUSTMENTS_b cdj,

3635:
3636: --cursor to fetch total trade in amount and description
3637: CURSOR get_ti_amt(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3638: SELECT sum(cdj.value) total_tradein
3639: FROM OKL_COST_ADJUSTMENTS_b cdj,
3640: OKL_ASSETS_B ast
3641: WHERE cdj.parent_object_id = ast.id
3642: AND cdj.parent_object_code = 'ASSET'
3643: AND cdj.adjustment_source_type = 'TRADEIN'