APPS.IBY_PAYGROUP_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 25394: * IBY_EXT_BANK_ACCOUNTS.bank_account_num

25390: /*
25391: * Fix for bug 5586882:
25392: *
25393: * Populate the external bank account using
25394: * IBY_EXT_BANK_ACCOUNTS.bank_account_num
25395: * so that we show the unmasked bank account number
25396: */
25397: ext_ba_table.bank_account_num, -- payee bank account number
25398:

Line 25415: IBY_EXT_BANK_ACCOUNTS_V eba,

25411: eba.primary_acct_owner_name -- payee bank primary acct owner name
25412:
25413: FROM
25414: /* Payee bank */
25415: IBY_EXT_BANK_ACCOUNTS_V eba,
25416: IBY_EXT_BANK_ACCOUNTS ext_ba_table,
25417: CE_BANK_BRANCHES_V eba_bank_branch
25418:
25419: WHERE

Line 25416: IBY_EXT_BANK_ACCOUNTS ext_ba_table,

25412:
25413: FROM
25414: /* Payee bank */
25415: IBY_EXT_BANK_ACCOUNTS_V eba,
25416: IBY_EXT_BANK_ACCOUNTS ext_ba_table,
25417: CE_BANK_BRANCHES_V eba_bank_branch
25418:
25419: WHERE
25420: /* payee bank */

Line 25447: FROM IBY_EXT_BANK_ACCOUNTS EBA,

25443: EBA.BANK_ACCOUNT_NAME_ALT ALTERNATE_ACCOUNT_NAME,
25444: EBA.BANK_ACCOUNT_NUM_ELECTRONIC,
25445: hzps.LOCATION_ID BANK_BRANCH_ADDRESS_ID,
25446: hzp.party_name PRIMARY_ACCT_OWNER_NAME
25447: FROM IBY_EXT_BANK_ACCOUNTS EBA,
25448: CE_BANK_BRANCHES_V EBA_BANK_BRANCH,
25449: IBY_ACCOUNT_OWNERS OW,
25450: HZ_PARTIES hzp,
25451: HZ_PARTY_SITES hzps