USP_DATALIST_GIFTAIDRULESTHATDISQUALIFYREVENUEAPPLICATION

This datalist returns a list of the gift aid disqualification rules applicable to the given revenue application.

Parameters

Parameter Parameter Type Mode Description
@REVENUESPLITID uniqueidentifier IN Input parameter indicating the context ID for the data list.

Definition

Copy


                CREATE procedure dbo.USP_DATALIST_GIFTAIDRULESTHATDISQUALIFYREVENUEAPPLICATION
                (
                    @REVENUESPLITID uniqueidentifier
                )
                as
                    set nocount on

                    select 
                        CATEGORY,
                        DESCRIPTION
                    from dbo.UFN_REVENUESPLIT_GETDISQUALIFICATIONS(@REVENUESPLITID, 1)
                    order by CATEGORY