APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1816: FROM IBY_EXT_BANK_ACCOUNTS

1812: p_country_code VARCHAR2,
1813: p_bank_account_id NUMBER) IS
1814:
1815: SELECT count(1)
1816: FROM IBY_EXT_BANK_ACCOUNTS
1817: WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
1818: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash
1819: (p_account_number,'F')
1820: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

Line 1840: FROM IBY_EXT_BANK_ACCOUNTS

1836: p_acct_type varchar2,
1837: p_acct_id NUMBER) IS
1838:
1839: SELECT count(1)
1840: FROM IBY_EXT_BANK_ACCOUNTS
1841: WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
1842: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash
1843: (p_account_number,'F')
1844: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

Line 1864: FROM IBY_EXT_BANK_ACCOUNTS

1860: p_acct_suffix varchar2,
1861: p_acct_id NUMBER) IS
1862:
1863: SELECT count(1)
1864: FROM IBY_EXT_BANK_ACCOUNTS
1865: WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
1866: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash
1867: (p_account_number,'F')
1868: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

Line 1913: FROM IBY_EXT_BANK_ACCOUNTS_V

1909: -- Account Name if specfied should be unique
1910: IF (p_ext_bank_acct_rec.bank_account_name <> NULL) THEN
1911: SELECT COUNT(EXT_BANK_ACCOUNT_ID)
1912: INTO l_count
1913: FROM IBY_EXT_BANK_ACCOUNTS_V
1914: WHERE BANK_ACCOUNT_NAME =p_ext_bank_acct_rec.bank_account_name;
1915:
1916: IF (l_count > 0) THEN
1917: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_NAME');