DBA Data[Home] [Help]

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:
377: IF (G_PO_WF_DEBUG = 'Y') THEN
378: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS FROM VENDOR CONTACT:' || L_EMAIL_ADDRESS);