APPS.AP_PAYMENT_EVENT_WF_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 16: l_email_address IBY_EXTERNAL_PAYEES_ALL.remit_advice_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 IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%type;
17:
18: l_message_lines1 varchar2(4000):='';
19: l_message_lines2 varchar2(4000):='';
20: l_message_lines3 varchar2(4000):='';

Line 234: FROM IBY_EXTERNAL_PAYEES_ALL

230: --bug6119080, changed the query to fetch the email address from the
231: --correct table.
232: SELECT remit_advice_email
233: INTO p_email_address
234: FROM IBY_EXTERNAL_PAYEES_ALL
235: WHERE supplier_site_id = l_vendor_site_id;
236:
237: END get_remit_email_address;
238:

Line 277: l_email_address IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%type;

273: i pls_integer;
274:
275: l_check_id l_parameter_t.value%type;
276: l_org_id l_parameter_t.value%type;
277: l_email_address IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%type;
278: l_check_status ap_checks_all.status_lookup_code%type;
279:
280: BEGIN
281: