TR_BENEFITGLDISTRIBUTION_UPDATE_GLTRANSACTION

                    CREATE trigger TR_BENEFITGLDISTRIBUTION_UPDATE_GLTRANSACTION on dbo.BENEFITGLDISTRIBUTION for update
                    as begin
                        set nocount on;
                        if update(REVENUEBENEFITID)
                            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_ADDBENEFITREVERSALS    @REVENUEID,@CHANGEAGENTID,@CHANGEDATE,@POSTDATE
                                    exec dbo.USP_GLTRANSACTION_ADDBENEFITLIABILITYREVERSALS @REVENUEID, @CHANGEAGENTID, @CHANGEDATE, @POSTDATE;
                                    exec dbo.USP_GLTRANSACTION_ADDBENEFITBACKOUTREVERSALS @REVENUEID, @CHANGEAGENTID, @CHANGEDATE, @POSTDATE;
                                end

                            end 
                    end