APPS.IBE_PARTY_V2PVT dependencies on HZ_PARTY_SITES

Line 2276: from hz_party_sites

2272: rec_contact_point c_getContactPoints%rowtype;
2273:
2274: cursor c_getPartySite(l_party_id number) IS
2275: select party_site_id,location_id,object_version_number
2276: from hz_party_sites
2277: where party_id = l_party_id;
2278: rec_party_site c_getPartySite%rowtype;
2279:
2280: cursor c_getPersonOrgPartyId(l_party_id number) IS

Line 2777: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

2773: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2774: l_location_id NUMBER;
2775: l_contact_preference_id NUMBER;
2776: l_party_site_id NUMBER;
2777: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
2778:
2779: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2780: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type := p_contact_pref_rec;
2781: l_person_rec HZ_PARTY_V2PUB.person_rec_type := p_person_rec;