DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_SUBPOOL_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 1326: OKL_LEASE_OPPORTUNITIES_B LEASEOPP

1322:
1323: CURSOR c_get_leaseopp_quote_id(p_leaseapp_id IN NUMBER) IS
1324: SELECT QUOTE.ID
1325: FROM OKL_LEASE_QUOTES_B QUOTE,
1326: OKL_LEASE_OPPORTUNITIES_B LEASEOPP
1327: WHERE QUOTE.PARENT_OBJECT_ID = LEASEOPP.ID
1328: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEOPP'
1329: AND QUOTE.STATUS = 'CT-ACCEPTED'
1330: AND LEASEOPP.ID = (SELECT LEASE_OPPORTUNITY_ID