USP_DATAFORMTEMPLATE_VIEW_GIFTAIDDISQUALIFICATIONREVENUEPAGEDATA

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

                    set @DATALOADED = 1;
                    set @SHOWSUMMARYSECTION = 0

                    declare @ISMEMBERSHIP bit


                    if dbo.UFN_RECURRINGGIFT_ISMEMBERSHIP(@ID) = 1
                        set @ISMEMBERSHIP = 1

                    if dbo.UFN_PLEDGE_ISMEMBERSHIP(@ID) = 1
                        set @ISMEMBERSHIP = 1

                    if @ISMEMBERSHIP = 1
                    begin
                        declare @MEMBERSHIPSPLIT uniqueidentifier

                        set @MEMBERSHIPSPLIT =
                            (select FINANCIALTRANSACTIONLINEITEM.ID
                        from dbo.FINANCIALTRANSACTIONLINEITEM
                        inner join dbo.MEMBERSHIPTRANSACTION  on MEMBERSHIPTRANSACTION.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
                        where FINANCIALTRANSACTIONID = @ID
                        and DELETEDON is null AND TYPECODE <> 1)

                        if exists(select ID from dbo.REVENUESPLITGIFTAID where ID = @MEMBERSHIPSPLIT and (RULES_STATUS = 0 or ATTRIBUTES_STATUS = 0 or DECLINESGIFTAID = 1))
                        begin
                            if exists(select ID from dbo.REVENUESPLITGIFTAID where ID = 
                            @MEMBERSHIPSPLIT and (RULES_STATUS & ATTRIBUTES_STATUS = 1) and DECLINESGIFTAID = 0)
                            begin
                                set @SHOWSUMMARYSECTION = 0
                            end
                            else
                            begin
                                set @SHOWSUMMARYSECTION = 1
                                set @SPLITDECLINED = @MEMBERSHIPSPLIT
                            end
                        end
                    end

    return 0;