APPS.PO_EMAIL_GENERATE dependencies on PO_VENDOR_CONTACTS

Line 2543: from po_vendor_contacts

2539: and PLL.po_line_id = POL.po_line_id;
2540:
2541: cursor vendor_contacts_cursor(v_vendor_contact_id NUMBER) IS
2542: select area_code || phone
2543: from po_vendor_contacts
2544: where vendor_contact_id = v_vendor_contact_id;
2545:
2546: l_document_status varchar2(100);
2547: l_price_break_count number := 0;

Line 3106: po_vendor_contacts where vendor_contact_id = l_vendor_contact_id;

3102: --EMAILPO FPH--
3103: -- Need to print the Supplier Contact Name
3104: begin
3105: select last_name || ',' || first_name into l_vendor_contact_name from
3106: po_vendor_contacts where vendor_contact_id = l_vendor_contact_id;
3107: exception
3108: when others then
3109: null;
3110: end;