TR_BENEFITGLDISTRIBUTION_UPDATE_GLTRANSACTION (Trigger)

                
                    CREATE trigger TR_BENEFITGLDISTRIBUTION_UPDATE_GLTRANSACTION on dbo.BENEFITGLDISTRIBUTION for update
                    as begin
                        set nocount on;
                        if update(REVENUEBENEFITID)
                            begin
                                delete from dbo.GLTRANSACTION where GLTRANSACTION.ID in (select GLTRANSACTIONID from inserted) and GLTRANSACTION.POSTSTATUSCODE = 1;
                                
                                declare @REVENUEID uniqueidentifier
                                declare @CHANGEAGENTID uniqueidentifier
                                declare    @CHANGEDATE datetime = GETDATE()
                                declare @POSTDATE datetime = GETDATE()
                                select  @REVENUEID = REVENUEID from inserted
                                select top 1 @CHANGEAGENTID = CHANGEDBYID from inserted where CHANGEDBYID is not null order by DATECHANGED

                                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