UFN_GIFTAIDREVENUESPLIT_SHOWREFUNDDETAILS

Determines if there are any refund details to show for the given application.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_SHOWREFUNDDETAILS
      (
      @ID uniqueidentifier
      )
      returns bit
      with execute as caller
      as begin

        if exists(select ID
                    from dbo.REVENUESPLITGIFTAIDREFUND
                    where REVENUESPLITID = @ID)
          return 1;

        return 0;
      end