TR_PROSPECTPLAN_INSERT_BASECURRENCYID (Trigger)

        
                    CREATE trigger [dbo].[TR_PROSPECTPLAN_INSERT_BASECURRENCYID] on [dbo].[PROSPECTPLAN] 
                    after insert
                    not for replication
                    as
                    begin
                        set nocount on;
                        
                        update dbo.PROSPECTPLAN set
                            PROSPECTPLAN.BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            PROSPECTPLAN.CHANGEDBYID = PROSPECTPLAN.CHANGEDBYID,
                            PROSPECTPLAN.DATECHANGED = PROSPECTPLAN.DATECHANGED
                        from 
                            inserted
                            inner join dbo.PROSPECTPLAN on inserted.ID = PROSPECTPLAN.ID
                        where
                            inserted.BASECURRENCYID is null;
                    end