APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_VENDOR_CONTACTS

Line 1845: FROM po_vendor_contacts pvc,

1841: pvc.last_name,
1842: fu.user_name,
1843: pvc.title INTO l_vendor_contact_first_name, l_vendor_contact_email_address, l_vendor_contact_phone, l_vendor_contact_id, l_vendor_contact_full_name,
1844: l_vendor_site_id, l_vendor_contact_fax, l_vendor_contact_last_name, l_user_name, l_vendor_contact_title
1845: FROM po_vendor_contacts pvc,
1846: fnd_user fu
1847: WHERE pvc.per_party_id = fu.person_party_id(+) AND vendor_contact_id = p_contact_id and vendor_site_id = p_supplier_site_id;
1848:
1849: l_vendor_cnt_concat := '';

Line 2374: FROM PO_VENDOR_CONTACTS

2370: Nvl(PREFIX,PREFIX ||' ')|| Nvl(FIRST_NAME,FIRST_NAME ||' ') || Nvl(MIDDLE_NAME,MIDDLE_NAME||' ') || LAST_NAME
2371: INTO l_phone_num,
2372: l_email,
2373: l_supplr_contact
2374: FROM PO_VENDOR_CONTACTS
2375: WHERE vendor_contact_id = x_contact_id
2376: AND vendor_site_id = x_supplier_site_id;
2377:
2378: p_hidd_contact_xml := get_supplier_contact_details(x_contact_id,x_supplier_site_id);

Line 2799: FROM PO_VENDOR_CONTACTS

2795: Nvl(PREFIX,PREFIX ||' ')|| Nvl(FIRST_NAME,FIRST_NAME ||' ') || Nvl(MIDDLE_NAME,MIDDLE_NAME||' ') || LAST_NAME
2796: INTO l_phone_num,
2797: l_email,
2798: l_supplr_contact
2799: FROM PO_VENDOR_CONTACTS
2800: WHERE vendor_contact_id = l_contact_id
2801: AND vendor_site_id = l_supplier_site_id;
2802:
2803: p_hidd_contact_xml := get_supplier_contact_details(l_contact_id,l_supplier_site_id);