UFN_BANKACCOUNTDEPOSIT_VALIDALLOWEDPAYMENTMETHODS

            CREATE function dbo.UFN_BANKACCOUNTDEPOSIT_VALIDALLOWEDPAYMENTMETHODS(@DEPOSITID uniqueidentifier,@DEFAULTALLOWEDPAYMENTMETHODS integer)
            returns bit
            with execute as caller
            as begin

            declare @RESULT bit = 1;

            if exists(select 1
                from dbo.BANKACCOUNTDEPOSITPAYMENT D
                inner join dbo.REVENUEPAYMENTMETHOD R on R.REVENUEID = D.ID
                where D.DEPOSITID = @DEPOSITID and (@DEFAULTALLOWEDPAYMENTMETHODS & (CASE R.PAYMENTMETHODCODE WHEN 0 THEN 2 WHEN 1 THEN 1 WHEN 2 THEN 8 WHEN 10 THEN 32 END)) = 0)
                    set @RESULT = 0;
            else if exists(select 1
                from BANKACCOUNTDEPOSITCORRECTION C
                where C.DEPOSITID = @DEPOSITID and (@DEFAULTALLOWEDPAYMENTMETHODS & (CASE C.PAYMENTMETHODCODE WHEN 0 THEN 2 WHEN 1 THEN 1 WHEN 2 THEN 8 WHEN 3 THEN 32 END)) = 0)
                    set @RESULT = 0;
            else if exists(select 1
                from dbo.BANKACCOUNTDEPOSITCREDITPAYMENT D
                inner join dbo.CREDITPAYMENT C on D.ID = C.ID
                where D.DEPOSITID = @DEPOSITID and (@DEFAULTALLOWEDPAYMENTMETHODS & (CASE C.PAYMENTMETHODCODE WHEN 0 THEN 2 WHEN 1 THEN 1 WHEN 2 THEN 8 WHEN 10 THEN 32 END)) = 0)
                    set @RESULT = 0;

            return @RESULT;
        end