3606: POC.MIDDLE_NAME MIDDLE_NAME,
3607: POC.LAST_NAME LAST_NAME
3608: FROM PO_VENDOR_CONTACTS POC,
3609: PO_VENDOR_SITES_ALL POS,
3610: PO_VENDORS POV
3611: -- HR_OPERATING_UNITS ORG
3612: WHERE POC.VENDOR_CONTACT_ID = l_supplier_contact_id
3613: AND POC.VENDOR_SITE_ID = POS.VENDOR_SITE_ID
3614: AND POS.VENDOR_ID = POV.VENDOR_ID;