Operation Details |
Description: | Returns the number of bank accounts of the specified status for the specified concern. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :value FROM ConcernRoleBankAccount, BankAccount WHERE concernRoleID = :concernRoleID AND BankAccount.bankAccountID = ConcernRoleBankAccount.bankAccountID AND BankAccount.statusCode <> :recordStatus |