APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_VENDOR_CONTACTS

Line 374: FROM PO_VENDOR_CONTACTS

370: IF L_EMAIL_ADDRESS IS NULL AND L_VENDOR_CONTACT_ID IS NOT NULL THEN
371: BEGIN
372: SELECT EMAIL_ADDRESS
373: INTO L_EMAIL_ADDRESS
374: FROM PO_VENDOR_CONTACTS
375: WHERE VENDOR_CONTACT_ID = L_VENDOR_CONTACT_ID
376: AND VENDOR_SITE_ID = L_VENDOR_SITE_ID;
377:
378: IF (G_PO_WF_DEBUG = 'Y') THEN