TR_GIFTFEEGLDISTRIBUTION_UPDATE_GLTRANSACTION

                    CREATE trigger TR_GIFTFEEGLDISTRIBUTION_UPDATE_GLTRANSACTION on dbo.GIFTFEEGLDISTRIBUTION for update
                    as begin
                        set nocount on;
                        if update(REVENUESPLITGIFTFEEID)
                            begin
                                if (select count(*) from INSERTED) > 0
                                begin
                                    declare @CHANGEAGENTID uniqueidentifier
                                    select top 1 @CHANGEAGENTID = CHANGEDBYID from inserted where CHANGEDBYID is not null order by DATECHANGED

                                    declare @CONTEXTCACHE varbinary(128) = CONTEXT_INFO()
                                    set CONTEXT_INFO @CHANGEAGENTID;

                                    delete from dbo.GLTRANSACTION where GLTRANSACTION.ID in (select GLTRANSACTIONID from inserted) and GLTRANSACTION.POSTSTATUSCODE = 1;

                                    if @CONTEXTCACHE is not null begin
                                        set CONTEXT_INFO @CONTEXTCACHE
                                    end;

                                    declare @REVENUEID uniqueidentifier
                                    declare    @CHANGEDATE datetime = GETDATE()
                                    declare @POSTDATE datetime = GETDATE()
                                    select  @REVENUEID = REVENUEID from inserted

                                    exec dbo.USP_GLTRANSACTION_ADDGIFTFEEREVERSALS    @REVENUEID,@CHANGEAGENTID,@CHANGEDATE,@POSTDATE
                                end
                            end 
                    end