TR_BATCHREVENUEBENEFIT_INSERTUPDATE_CURRENCY (Trigger)

                
                    create trigger [dbo].[TR_BATCHREVENUEBENEFIT_INSERTUPDATE_CURRENCY] on [dbo].[BATCHREVENUEBENEFIT] 
                    after insert
                    not for replication
                    as begin
                        set nocount on;

                        update
                            dbo.BATCHREVENUEBENEFIT
                        set
                            BATCHREVENUEBENEFIT.BENEFITCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            BATCHREVENUEBENEFIT.CHANGEDBYID = BATCHREVENUEBENEFIT.CHANGEDBYID,
                            BATCHREVENUEBENEFIT.DATECHANGED = BATCHREVENUEBENEFIT.DATECHANGED
                        from 
                            inserted
                            inner join dbo.BATCHREVENUEBENEFIT on inserted.ID = BATCHREVENUEBENEFIT.ID
                        where 
                            BATCHREVENUEBENEFIT.BENEFITCURRENCYID is null;
                    end