APPS.POS_COMPARE_REVISIONS dependencies on PO_VENDOR_CONTACTS

Line 378: * PO_VENDOR_CONTACTS table.

374: * Resolves the supplier contact.
375: *
376: * ARGUMENTS
377: * p_vendor_contact_id Unique identifier for vendor in
378: * PO_VENDOR_CONTACTS table.
379: *
380: * NOTES
381: * Return NULL if no matching records were found.
382: *

Line 386: * Obtain name from PO_VENDOR_CONTACTS

382: *
383: * HISTORY
384: * 08-AUG-97 Nilo Paredes Created
385: * 22-SEP-97 Rami Haddad Return NULL if no values found.
386: * Obtain name from PO_VENDOR_CONTACTS
387: * table.
388: ********************************************************************/
389: FUNCTION get_vendor_contact( p_vendor_contact_id IN NUMBER )
390: RETURN VARCHAR2 AS

Line 401: FROM po_vendor_contacts

397: v_progress := '080';
398:
399: SELECT DECODE(last_name, NULL, NULL, last_name || ',' || first_name)
400: INTO v_full_name
401: FROM po_vendor_contacts
402: WHERE vendor_contact_id = p_vendor_contact_id;
403:
404: RETURN v_full_name;
405: