APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 134: FROM OKL_LEASE_APPLICATIONS_B LAB

130: CURSOR l_uniq_contract_csr(p_qte_id NUMBER)
131: IS
132: SELECT LAB.REFERENCE_NUMBER LSE_APP
133: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
134: FROM OKL_LEASE_APPLICATIONS_B LAB
135: , OKL_LEASE_QUOTES_B QTE
136: , OKC_K_HEADERS_B CHR
137: , OKC_STATUSES_V CSTS
138: WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID

Line 309: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS

305: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
309: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS
310: -- Variables Declarations
311: l_api_version CONSTANT NUMBER DEFAULT 1.0;
312: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPD_LP_STS';
313: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 4536: okl_lease_applications_b olav

4532: -- Cursor to get the contract template attached to a lease application template of a lease app
4533: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4534: SELECT olvv.contract_template_id
4535: FROM okl_leaseapp_templ_versions_b olvv,
4536: okl_lease_applications_b olav
4537: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
4538: AND olav.ID = p_lap_id
4539: AND EXISTS (SELECT 1
4540: FROM okl_k_headers khr

Line 5354: okl_lease_applications_b olav,

5350: , khr.ATTRIBUTE1, khr.ATTRIBUTE2, khr.ATTRIBUTE3, khr.ATTRIBUTE4, khr.ATTRIBUTE5, khr.ATTRIBUTE6
5351: , khr.ATTRIBUTE7, khr.ATTRIBUTE8, khr.ATTRIBUTE9, khr.ATTRIBUTE10, khr.ATTRIBUTE11, khr.ATTRIBUTE12
5352: , khr.ATTRIBUTE13, khr.ATTRIBUTE14, khr.ATTRIBUTE15
5353: FROM okl_leaseapp_templ_versions_b olvv,
5354: okl_lease_applications_b olav,
5355: okc_k_headers_v chr,
5356: okl_k_headers khr
5357: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
5358: AND olav.ID = p_lap_id