[Home] [Help]
8:
9: l_qte_cntrct_ast_tbl qte_cntrct_ast_tbl_type;
10:
11: --Get the lease app header information
12: CURSOR c_get_leaseapp_hdr(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
13: SELECT olav.ID,
14: olav.REFERENCE_NUMBER,
15: olav.PROSPECT_ID,
16: olav.PROSPECT_ADDRESS_ID,
44: olqv.EXPECTED_FUNDING_DATE,
45: olqv.LEGAL_ENTITY_ID,
46: olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
47: ,olav.SHORT_DESCRIPTION -- ER# 9161779
48: FROM okl_lease_applications_v olav,
49: okl_lease_quotes_v olqv
50: WHERE olqv.PARENT_OBJECT_CODE = 'LEASEAPP'
51: AND olqv.PARENT_OBJECT_ID = olav.ID
52: AND olav.APPLICATION_STATUS = 'CR-APPROVED'
4250: lp_rgr_tbl OKL_RGRP_RULES_PROCESS_PVT.rgr_tbl_type;
4251: i NUMBER;
4252: --Cursor declaration
4253: --Get the contract template id associated with lease app template
4254: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4255: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4256: FROM okl_leaseapp_templ_versions_v olvv,
4257: okl_lease_applications_v olav
4258: WHERE olav.leaseapp_template_id = olvv.ID
4253: --Get the contract template id associated with lease app template
4254: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4255: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4256: FROM okl_leaseapp_templ_versions_v olvv,
4257: okl_lease_applications_v olav
4258: WHERE olav.leaseapp_template_id = olvv.ID
4259: AND olav.ID = p_lap_id;
4260:
4261: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4518: FROM OKC_ROLE_SOURCES
4519: WHERE rle_code = p_rle_code
4520: AND buy_or_sell = 'S';
4521: --Get the vendor id
4522: CURSOR c_cplv (p_khr_id IN okl_lease_applications_v.PROGRAM_AGREEMENT_ID%TYPE) IS
4523: SELECT cpl.id, cpl.object1_id1
4524: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
4525: WHERE dnz_chr_id = p_khr_id
4526: AND cpl.rle_code = ROLES.rle_code
4529: AND cpl.cle_id IS NULL;
4530:
4531: -- ER# 9161779 - Start
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
4543: ;
4544:
4545: --Bug# 12748315: Modified to fetch Party Name from HZ_PARTIES
4546: -- From lease application, get to the case folder and fetch all guarantors
4547: CURSOR c_get_guarantors(cp_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4548: SELECT hzp.party_name, credreq.trx_amount amount_requested, gdata.*
4549: FROM ar_cmgt_credit_requests credreq,
4550: ar_cmgt_guarantor_data gdata,
4551: hz_parties hzp
4578:
4579: -- Cursor to get parties of the contract template - parties other than Lessee, Lessor, Vendor
4580: -- Get Guarantors from contract template and those that are not in case folder of lease app
4581: CURSOR c_get_other_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4582: ,cp_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4583: SELECT p_role.ID,
4584: p_role.object1_id1,
4585: p_role.object1_id2,
4586: p_role.jtot_object1_code,
5344: -- End (Bug 5142890)
5345:
5346: -- ER# 9161779 - Start
5347: -- Cursor to get the contract template attached to a lease application template of a lease app
5348: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
5349: SELECT chr.id , chr.description, khr.ATTRIBUTE_CATEGORY
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