APPS.OKL_EC_UPTAKE_PVT dependencies on OKL_ASSETS_B

Line 75: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

71: --Bug 5045505 ssdeshpa start
72: --Added Cursors to get Deal Size of LQ
73: CURSOR c_deal_size_cur(p_parent_object_id NUMBER) IS
74: select SUM(OEC)
75: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
76: where OAB.PARENT_OBJECT_ID = OLQ.ID
77: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
78: AND OLQ.ID= p_parent_object_id;
79:

Line 83: OKL_ASSETS_B OAB

79:
80: cursor c_lq_cost_adj_rec(p_quote_id NUMBER,p_adj_type VARCHAR2) IS
81: SELECT SUM(NVL(VALUE,0))
82: FROM OKL_COST_ADJUSTMENTS_B OCA,
83: OKL_ASSETS_B OAB
84: where OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
85: AND OCA.PARENT_OBJECT_CODE='ASSET'
86: AND OCA.PARENT_OBJECT_ID=OAB.ID
87: and ADJUSTMENT_SOURCE_TYPE =p_adj_type

Line 93: OKL_ASSETS_B OAB

89:
90: CURSOR c_cost_comp_cur(p_quote_id NUMBER) IS
91: select OAC.INV_ITEM_ID
92: from OKL_ASSET_COMPONENTS_B OAC,
93: OKL_ASSETS_B OAB
94: WHERE OAC.ASSET_ID = OAB.ID
95: AND OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
96: AND PRIMARY_COMPONENT='YES'
97: AND OAB.PARENT_OBJECT_ID = p_quote_id;