[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,
43: olqv.EXPECTED_DELIVERY_DATE,
44: olqv.EXPECTED_FUNDING_DATE,
45: olqv.LEGAL_ENTITY_ID,
46: olqv.LINE_INTENDED_USE -- Bug 5908845. eBTax Enhancement Project
47: FROM okl_lease_applications_v olav,
48: okl_lease_quotes_v olqv
49: WHERE olqv.PARENT_OBJECT_CODE = 'LEASEAPP'
50: AND olqv.PARENT_OBJECT_ID = olav.ID
51: AND olav.APPLICATION_STATUS = 'CR-APPROVED'
4143: lp_rgr_tbl OKL_RGRP_RULES_PROCESS_PVT.rgr_tbl_type;
4144: i NUMBER;
4145: --Cursor declaration
4146: --Get the contract template id associated with lease app template
4147: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4148: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4149: FROM okl_leaseapp_templ_versions_v olvv,
4150: okl_lease_applications_v olav
4151: WHERE olav.leaseapp_template_id = olvv.ID
4146: --Get the contract template id associated with lease app template
4147: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4148: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4149: FROM okl_leaseapp_templ_versions_v olvv,
4150: okl_lease_applications_v olav
4151: WHERE olav.leaseapp_template_id = olvv.ID
4152: AND olav.ID = p_lap_id;
4153:
4154: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4405: FROM OKC_ROLE_SOURCES
4406: WHERE rle_code = p_rle_code
4407: AND buy_or_sell = 'S';
4408: --Get the vendor id
4409: CURSOR c_cplv (p_khr_id IN okl_lease_applications_v.PROGRAM_AGREEMENT_ID%TYPE) IS
4410: SELECT cpl.id, cpl.object1_id1
4411: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
4412: WHERE dnz_chr_id = p_khr_id
4413: AND cpl.rle_code = ROLES.rle_code