APPS.POS_SUPPLIER_CONTACT_BO_PKG dependencies on HZ_PARTY_SITES

Line 391: FROM hz_party_sites

387: ELSE
388: IF (p_vendor_contact_rec.party_site_name IS NOT NULL) THEN
389: SELECT party_site_id
390: INTO p_vendor_contact_rec.org_party_site_id
391: FROM hz_party_sites
392: WHERE party_id = l_party_id
393: AND party_site_name = p_vendor_contact_rec.party_site_name;
394:
395: pos_supplier_address_pkg.assign_address_to_contact(p_contact_party_id => p_vendor_contact_rec.per_party_id,