APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_VENDOR_SITES_ALL

Line 327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS

323: IF (L_REQ_SUPPLIER_ID IS NOT NULL) THEN
324:
325: SELECT PRS.VENDOR_SITE_ID, PRS.VENDOR_CONTACT_ID, PVS.VENDOR_SITE_CODE, PVS.LANGUAGE
326: INTO L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG
327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS
328: WHERE PRS.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
329: AND PRS.REQUISITION_SUPPLIER_ID = L_REQ_SUPPLIER_ID;
330:
331: ELSIF (L_REQ_LINE_ID IS NOT NULL) THEN

Line 335: FROM PO_REQUISITION_LINES PRL, PO_VENDOR_SITES_ALL PVS

331: ELSIF (L_REQ_LINE_ID IS NOT NULL) THEN
332:
333: SELECT PRL.VENDOR_SITE_ID, PRL.VENDOR_CONTACT_ID, PVS.VENDOR_SITE_CODE, PVS.LANGUAGE
334: INTO L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG
335: FROM PO_REQUISITION_LINES PRL, PO_VENDOR_SITES_ALL PVS
336: WHERE PRL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
337: AND PRL.REQUISITION_LINE_ID = L_REQ_LINE_ID;
338:
339: END IF;

Line 358: FROM PO_VENDOR_SITES_ALL

354: --GET EMAIL ADDRESS FROM SUPPLIER SITE
355: BEGIN
356: SELECT EMAIL_ADDRESS
357: INTO L_EMAIL_ADDRESS
358: FROM PO_VENDOR_SITES_ALL
359: WHERE VENDOR_SITE_ID = L_VENDOR_SITE_ID;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: L_EMAIL_ADDRESS := NULL;