APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_OPPORTUNITIES_V

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

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

Line 93: FROM okl_lease_opportunities_v olov,

89: olqv.EXPECTED_FUNDING_DATE,
90: olqv.LEGAL_ENTITY_ID,
91: olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
92: ,olov.SHORT_DESCRIPTION -- ER# 9161779
93: FROM okl_lease_opportunities_v olov,
94: okl_lease_quotes_v olqv
95: WHERE olqv.PARENT_OBJECT_CODE = 'LEASEOPP'
96: AND olqv.PARENT_OBJECT_ID = olov.ID
97: AND olqv.status = 'CT-ACCEPTED'