111: pohd.vendor_site_id = p_vendor_site_id,
112: pohd.vendor_contact_id = (SELECT vendor_contact_id
113: FROM ap_supplier_contacts
114: WHERE org_party_site_id = (SELECT party_site_id
115: FROM ap_supplier_sites_all
116: WHERE vendor_site_id = p_vendor_site_id)
117: AND per_party_id = (SELECT per_party_id
118: FROM ap_supplier_contacts
119: WHERE vendor_contact_id = pohd.vendor_contact_id)),
158: ph.vendor_site_id = p_vendor_site_id,
159: ph.vendor_contact_id = (SELECT vendor_contact_id
160: FROM ap_supplier_contacts
161: WHERE org_party_site_id = (SELECT party_site_id
162: FROM ap_supplier_sites_all
163: WHERE vendor_site_id = p_vendor_site_id)
164: AND per_party_id = (SELECT per_party_id
165: FROM ap_supplier_contacts
166: WHERE vendor_contact_id = ph.vendor_contact_id)),