APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_OPPORTUNITIES_V

Line 56: CURSOR c_get_leaseopp_hdr(p_lop_id IN okl_lease_opportunities_v.ID%TYPE) IS

52: AND olqv.primary_quote = 'Y'
53: AND olav.ID = p_lap_id;
54:
55: --Get the lease opp header information
56: CURSOR c_get_leaseopp_hdr(p_lop_id IN okl_lease_opportunities_v.ID%TYPE) IS
57: SELECT olov.ID,
58: olov.REFERENCE_NUMBER,
59: olov.PROSPECT_ID,
60: olov.PROSPECT_ADDRESS_ID,

Line 91: FROM okl_lease_opportunities_v olov,

87: olqv.EXPECTED_DELIVERY_DATE,
88: olqv.EXPECTED_FUNDING_DATE,
89: olqv.LEGAL_ENTITY_ID,
90: olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
91: FROM okl_lease_opportunities_v olov,
92: okl_lease_quotes_v olqv
93: WHERE olqv.PARENT_OBJECT_CODE = 'LEASEOPP'
94: AND olqv.PARENT_OBJECT_ID = olov.ID
95: AND olqv.status = 'CT-ACCEPTED'