DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT dependencies on OKL_LEASE_QUOTES_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 247: FROM OKL_LEASE_QUOTES_b

243: l_parent_object_code VARCHAR2(30);
244:
245: CURSOR c_lq_rec(p_lease_quote_id NUMBER) IS
246: SELECT PARENT_OBJECT_ID,PARENT_OBJECT_CODE
247: FROM OKL_LEASE_QUOTES_b
248: where id=p_lease_quote_id;
249: CURSOR c_lop_rec(p_object_id NUMBER) IS
250: select PROGRAM_AGREEMENT_ID
251: from okl_lease_opportunities_b