TR_FUNDINGPLAN_INSERT_BASECURRENCYID (Trigger)

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