APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_ASSET_COMPONENTS_B

Line 214: from OKL_ASSET_COMPONENTS_B OAC,

210: AND OAB.PARENT_OBJECT_ID = p_quote_id;
211: --Addes cursor to get Item For LQ
212: CURSOR c_cost_comp_cur(p_quote_id NUMBER) IS
213: select OAC.INV_ITEM_ID
214: from OKL_ASSET_COMPONENTS_B OAC,
215: OKL_ASSETS_B OAB
216: WHERE OAC.ASSET_ID = OAB.ID
217: AND OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
218: AND PRIMARY_COMPONENT='YES'

Line 1466: okl_asset_components_b oac

1462: --Fix Bug # 4898499 Start
1463: cursor c_lq_asset_comp_rec(p_lease_quote_id NUMBER) IS
1464: select oac.unit_cost
1465: from okl_assets_b oab,
1466: okl_asset_components_b oac
1467: where oab.parent_object_code='LEASEQUOTE'
1468: AND oab.id=oac.asset_id
1469: AND oac.primary_component='YES'
1470: AND oab.parent_object_id=p_lease_quote_id;