USP_DATAFORMTEMPLATE_VIEW_GIFTAIDDISQUALIFICATIONREVENUEAPPLICATIONPAGEDATA

                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GIFTAIDDISQUALIFICATIONREVENUEAPPLICATIONPAGEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SHOWSUMMARYSECTION bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @SHOWSUMMARYSECTION = 0;

                    declare @DECLINESGIFTAID bit;
                    declare @GIFTAIDEXPIRED bit;

                    select
                        @DECLINESGIFTAID = REVENUESPLITGIFTAID.DECLINESGIFTAID,
                        @GIFTAIDEXPIRED = dbo.UFN_REVENUESPLITGIFTAID_GIFTAIDEXPIRED(REVENUESPLITGIFTAID.ID),
                        @DATALOADED = 1
                    from 
                        dbo.REVENUESPLITGIFTAID
                    where 
                        ID = @ID;

                    if @DECLINESGIFTAID = 1 or @GIFTAIDEXPIRED = 1
                    begin
                        set @SHOWSUMMARYSECTION = 1;
                    end

                    return 0;