APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on HZ_PARTY_SITES

Line 4623: FROM HZ_PARTY_SITES

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'
4626: AND identifying_address_flag = 'Y' ;
4627:

Line 4640: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

4636: lx_rmpv_rec OKL_RULE_PUB.rmpv_rec_type;
4637:
4638: c_get_party_rec c_get_party_csr%ROWTYPE;
4639: l_chr_tmpl_id OKC_K_HEADERS_B.ID%TYPE;
4640: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
4641: lx_cpl_id NUMBER;
4642: l_rrd_id NUMBER;
4643: l_create_party_for_lap BOOLEAN;
4644: l_tmp NUMBER;