TR_APPEAL_INSERTUPDATE_CURRENCY (Trigger)

                    
                        CREATE trigger [dbo].[TR_APPEAL_INSERTUPDATE_CURRENCY] on [dbo].[APPEAL]
                            after insert, update
                            not for replication
                            as
                            begin
                                set nocount on;
                            
                                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                                if update(GOAL)
                                update
                                    dbo.APPEAL
                                set
                                    APPEAL.ORGANIZATIONGOAL = APPEAL.GOAL,
                                    APPEAL.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                                    APPEAL.CHANGEDBYID = APPEAL.CHANGEDBYID,
                                    APPEAL.DATECHANGED = APPEAL.DATECHANGED
                                from
                                    inserted
                                inner join
                                    dbo.APPEAL on inserted.ID = APPEAL.ID
                                where
                                    APPEAL.ORGANIZATIONEXCHANGERATEID is null
                                    and (APPEAL.BASECURRENCYID is null or APPEAL.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
                                    and
                                    (
                                        APPEAL.ORGANIZATIONGOAL <> APPEAL.GOAL
                                        or APPEAL.GOAL = 0
                                    );
                            end