APPS.AP_WEB_UTIL_PKG dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 103: l_account IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_NUMBER%TYPE := NULL; --1684954

99: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
100: l_employeeID PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;
101: l_paid_on_behalf_employee_id AP_INVOICES_ALL.PAID_ON_BEHALF_EMPLOYEE_ID%TYPE := NULL;
102: l_invoiceNumber AP_INVOICES_ALL.INVOICE_NUM%TYPE;
103: l_account IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_NUMBER%TYPE := NULL; --1684954
104: l_bankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE := NULL; --1758619
105: l_cardIssuer PO_VENDORS.VENDOR_NAME%TYPE;
106: l_paidAmount AP_INVOICES_ALL.PAY_CURR_INVOICE_AMOUNT%TYPE;
107:

Line 104: l_bankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE := NULL; --1758619

100: l_employeeID PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;
101: l_paid_on_behalf_employee_id AP_INVOICES_ALL.PAID_ON_BEHALF_EMPLOYEE_ID%TYPE := NULL;
102: l_invoiceNumber AP_INVOICES_ALL.INVOICE_NUM%TYPE;
103: l_account IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_NUMBER%TYPE := NULL; --1684954
104: l_bankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE := NULL; --1758619
105: l_cardIssuer PO_VENDORS.VENDOR_NAME%TYPE;
106: l_paidAmount AP_INVOICES_ALL.PAY_CURR_INVOICE_AMOUNT%TYPE;
107:
108: l_flag NUMBER := 0;

Line 170: FROM IBY_EXT_BANK_ACCOUNTS_V

166: SELECT bank_account_number,
167: bank_name||','||bank_branch_name
168: INTO l_account,
169: l_bankName
170: FROM IBY_EXT_BANK_ACCOUNTS_V
171: WHERE ext_bank_account_id = l_ext_bank_account_id
172: AND rownum = 1;
173: end if;
174: LogStatement('NotifyEmployeeOnPayment', 'Bank Information ' || l_account || ' ' || l_bankName );