APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1697: FROM IBY_EXT_BANK_ACCOUNTS

1693: p_country_code VARCHAR2,
1694: p_bank_account_id NUMBER) IS
1695:
1696: SELECT count(1)
1697: FROM IBY_EXT_BANK_ACCOUNTS
1698: WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
1699: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash
1700: (p_account_number,'F')
1701: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

Line 1744: FROM IBY_EXT_BANK_ACCOUNTS_V

1740: -- Account Name if specfied should be unique
1741: IF (p_ext_bank_acct_rec.bank_account_name <> NULL) THEN
1742: SELECT COUNT(EXT_BANK_ACCOUNT_ID)
1743: INTO l_count
1744: FROM IBY_EXT_BANK_ACCOUNTS_V
1745: WHERE BANK_ACCOUNT_NAME =p_ext_bank_acct_rec.bank_account_name;
1746:
1747: IF (l_count > 0) THEN
1748: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_NAME');