TR_BATCHREVENUEAPPLICATIONPLEDGEBENEFIT_INSERTUPDATE_CURRENCY (Trigger)

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

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