TR_BENEFIT_INSERT_BASECURRENCYID (Trigger)

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