TR_OPPORTUNITYAMOUNTBRACKETGROUP_INSERTUPDATE_CURRENCY (Trigger)

        
            create trigger [dbo].[TR_OPPORTUNITYAMOUNTBRACKETGROUP_INSERTUPDATE_CURRENCY] on [dbo].[OPPORTUNITYAMOUNTBRACKETGROUP] 
            after insert, update 
            not for replication
            as
            begin
                set nocount on;
             
                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                
                update
                    dbo.OPPORTUNITYAMOUNTBRACKETGROUP
                set
                    OPPORTUNITYAMOUNTBRACKETGROUP.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                    OPPORTUNITYAMOUNTBRACKETGROUP.CHANGEDBYID = OPPORTUNITYAMOUNTBRACKETGROUP.CHANGEDBYID,
                    OPPORTUNITYAMOUNTBRACKETGROUP.DATECHANGED = OPPORTUNITYAMOUNTBRACKETGROUP.DATECHANGED
                from
                    inserted
                inner join
                    dbo.OPPORTUNITYAMOUNTBRACKETGROUP on inserted.ID = OPPORTUNITYAMOUNTBRACKETGROUP.ID
                where
                    OPPORTUNITYAMOUNTBRACKETGROUP.BASECURRENCYID is null
            end