TR_GIFTFEEGLDISTRIBUTION_UPDATE_GLTRANSACTION (Trigger)

                
                    CREATE trigger TR_GIFTFEEGLDISTRIBUTION_UPDATE_GLTRANSACTION on dbo.GIFTFEEGLDISTRIBUTION for update
                    as begin
                        set nocount on;
                        if update(REVENUESPLITGIFTFEEID)
                            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_ADDGIFTFEEREVERSALS    @REVENUEID,@CHANGEAGENTID,@CHANGEDATE,@POSTDATE
                            end 
                    end