APPS.FUN_CONTACTUS_EMAIL dependencies on PO_VENDOR_CONTACTS

Line 244: FROM fnd_user fu, po_vendor_contacts pvc

240: ELSIF (l_vendor_id IS NOT NULL) THEN
241: -- FND User is a supplier
242: SELECT pvc.last_name || ', ' || pvc.first_name full_name, pvc.email_address email_address
243: INTO p_full_name, p_email_address
244: FROM fnd_user fu, po_vendor_contacts pvc
245: WHERE fu.supplier_id IS NOT NULL
246: AND fu.supplier_id = pvc.vendor_contact_id
247: AND NVL(pvc.inactive_date, SYSDATE) >= SYSDATE
248: AND fu.user_id = p_user_id;