APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on IBY_SECURITY_PKG

Line 1818: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash

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

Line 1820: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

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
1821: (p_account_number,'T') ))
1822: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
1823: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
1824: AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))

Line 1842: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash

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

Line 1844: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

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
1845: (p_account_number,'T') ))
1846: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
1847: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
1848: AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))

Line 1866: (BANK_ACCOUNT_NUM_HASH1= iby_security_pkg.Get_Hash

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

Line 1868: AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash

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
1869: (p_account_number,'T') ))
1870: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
1871: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
1872: AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))