DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on IBY_SECURITY_PKG

Line 1699: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash

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
1702: (p_account_number,'T') ))
1703: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))

Line 1701: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

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
1702: (p_account_number,'T') ))
1703: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
1704: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
1705: AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))