APPS.PO_COMPARE_REVISIONS dependencies on PO_VENDOR_CONTACTS

Line 321: * PO_VENDOR_CONTACTS table.

317: * Resolves the supplier contact.
318: *
319: * ARGUMENTS
320: * p_vendor_contact_id Unique identifier for vendor in
321: * PO_VENDOR_CONTACTS table.
322: *
323: * NOTES
324: * Return NULL if no matching records were found.
325: *

Line 329: * Obtain name from PO_VENDOR_CONTACTS

325: *
326: * HISTORY
327: * 08-AUG-97 Nilo Paredes Created
328: * 22-SEP-97 Rami Haddad Return NULL if no values found.
329: * Obtain name from PO_VENDOR_CONTACTS
330: * table.
331: ********************************************************************/
332: FUNCTION get_vendor_contact( p_vendor_contact_id IN NUMBER )
333: RETURN VARCHAR2 AS

Line 344: FROM po_vendor_contacts

340: v_progress := '080';
341:
342: SELECT DECODE(last_name, NULL, NULL, last_name || ',' || first_name)
343: INTO v_full_name
344: FROM po_vendor_contacts
345: WHERE vendor_contact_id = p_vendor_contact_id;
346:
347: RETURN v_full_name;
348: