APPS.AP_PAYMENT_EVENT_WF_PKG dependencies on PO_VENDOR_SITES_ALL

Line 16: l_email_address po_vendor_sites_all.remittance_email%type;

12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;
15: l_payment_amount ap_checks_all.amount%type;
16: l_email_address po_vendor_sites_all.remittance_email%type;
17:
18: l_message_lines1 varchar2(4000):='';
19: l_message_lines2 varchar2(4000):='';
20: l_message_lines3 varchar2(4000):='';

Line 208: l_vendor_id po_vendor_sites_all.vendor_id%type;

204:
205: PROCEDURE get_remit_email_address (p_check_id in NUMBER,
206: p_email_address out NOCOPY VARCHAR2) is
207:
208: l_vendor_id po_vendor_sites_all.vendor_id%type;
209: l_vendor_site_id po_vendor_sites_all.vendor_site_id%type;
210:
211: BEGIN
212:

Line 209: l_vendor_site_id po_vendor_sites_all.vendor_site_id%type;

205: PROCEDURE get_remit_email_address (p_check_id in NUMBER,
206: p_email_address out NOCOPY VARCHAR2) is
207:
208: l_vendor_id po_vendor_sites_all.vendor_id%type;
209: l_vendor_site_id po_vendor_sites_all.vendor_site_id%type;
210:
211: BEGIN
212:
213: SELECT vendor_id,

Line 267: l_email_address po_vendor_sites_all.remittance_email%type;

263: i pls_integer;
264:
265: l_check_id l_parameter_t.value%type;
266: l_org_id l_parameter_t.value%type;
267: l_email_address po_vendor_sites_all.remittance_email%type;
268: l_check_status ap_checks_all.status_lookup_code%type;
269:
270: BEGIN
271: