APPS.PO_EMAIL_GENERATE dependencies on PO_VENDOR_CONTACTS

Line 2764: from po_vendor_contacts

2760: and PLL.po_line_id = POL.po_line_id;
2761:
2762: cursor vendor_contacts_cursor(v_vendor_contact_id NUMBER) IS
2763: select area_code || phone
2764: from po_vendor_contacts
2765: where vendor_contact_id = v_vendor_contact_id;
2766:
2767: l_document_status varchar2(100);
2768: l_price_break_count number := 0;

Line 3537: po_vendor_contacts where vendor_contact_id = l_vendor_contact_id;

3533: --EMAILPO FPH--
3534: -- Need to print the Supplier Contact Name
3535: begin
3536: select last_name || ',' || first_name into l_vendor_contact_name from
3537: po_vendor_contacts where vendor_contact_id = l_vendor_contact_id;
3538: exception
3539: when others then
3540: null;
3541: end;