UFN_DISCOUNT_ISCONSTITUENTRECOGNITION

      create function dbo.UFN_DISCOUNT_ISCONSTITUENTRECOGNITION
      (
        @CONSTITUENTID uniqueidentifier
      ) 
      returns bit
            with execute as caller
            as begin
        if exists(
          select CONSTITUENTID
          from dbo.CONSTITUENTRECOGNITION
          where CONSTITUENTRECOGNITION.CONSTITUENTID = @CONSTITUENTID
                  and (CONSTITUENTRECOGNITION.EXPIRATIONDATE >= getdate() or
                       dbo.UFN_RECOGNITIONPROGRAM_GETTYPECODE(CONSTITUENTRECOGNITION.RECOGNITIONPROGRAMID) = 1)
          ) 
          return 1;

         return 0;
      end