APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on HZ_PARTIES

Line 4545: --Bug# 12748315: Modified to fetch Party Name from HZ_PARTIES

4541: WHERE khr.ID = olvv.contract_template_id
4542: AND khr.template_type_code = 'CONTRACT') -- Consider only contract templates and not lease app contract templates
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,

Line 4551: hz_parties hzp

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
4552: WHERE gdata.credit_request_id = credreq.credit_request_id
4553: AND credreq.source_column3 = 'LEASEAPP'
4554: AND credreq.source_column1 = cp_lap_id
4555: AND hzp.party_id = gdata.party_id;

Line 4621: CURSOR c_get_primary_address(cp_party_id HZ_PARTIES.PARTY_ID%TYPE ) IS

4617: and rgrdfs.srd_id = rgdfs.id
4618: and rgrdfs.sre_id = sre.id;
4619:
4620:
4621: CURSOR c_get_primary_address(cp_party_id HZ_PARTIES.PARTY_ID%TYPE ) IS
4622: SELECT PARTY_SITE_ID
4623: FROM HZ_PARTY_SITES
4624: WHERE party_id = cp_party_id
4625: AND status = 'A'

Line 5097: --Bug# 12748315: Use party_name from hz_parties

5093: p_lty_code => null,--Line style
5094: p_rle_code => lp_cplv_rec.rle_code,
5095: p_id1 => lp_cplv_rec.object1_id1,
5096: p_id2 => lp_cplv_rec.object1_id2,
5097: --Bug# 12748315: Use party_name from hz_parties
5098: p_name => c_get_guarantors_rec.PARTY_NAME,
5099: p_object_code => 'OKX_PARTY');
5100: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;