UFN_REVENUESPLIT_MATCHEDBYDONORCHALLENGE

      CREATE function dbo.UFN_REVENUESPLIT_MATCHEDBYDONORCHALLENGE
      (
        @REVENUESPLITID uniqueidentifier
      )
      returns bit
      with execute as caller
      as begin

        if exists 
        (
          select 1 from dbo.DONORCHALLENGEENCUMBERED
          inner join dbo.DONORCHALLENGE on DONORCHALLENGEENCUMBERED.DONORCHALLENGEID = DONORCHALLENGE.ID 
          inner join dbo.FINANCIALTRANSACTIONLINEITEM REVENUESPLIT on DONORCHALLENGEENCUMBERED.REVENUESPLITID = REVENUESPLIT.ID
          inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = REVENUESPLIT.ID
          inner join dbo.FINANCIALTRANSACTION REVENUE on REVENUESPLIT.FINANCIALTRANSACTIONID = REVENUE.ID
          where DONORCHALLENGE.TYPECODE = 0 --Match per gift

            and DONORCHALLENGEENCUMBERED.STATUSTYPECODE = 1 --Matched

            and REVENUESPLIT.ID = @REVENUESPLITID 
            and REVENUE.TYPECODE = 0 --payment

            and REVENUESPLIT.DELETEDON is null and REVENUESPLIT.TYPECODE != 1
        )    
          return 1;

        return 0;
      end