USP_FENXT_ADDACCOUNTFUNDREQUIREMENT

            create procedure dbo.USP_FENXT_ADDACCOUNTFUNDREQUIREMENT
                (
                @PDACCOUNTSYSTEMID uniqueidentifier,
                @FUNDID int,
                @FUNDVALUE nvarchar(100),
                @FUNDDESCRIPTION nvarchar(100),
                @PROJECTREQUIREONACCOUNTSSPECIFIED nvarchar(30)
                )
                as

                    declare @CHANGEAGENTID uniqueidentifier;
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                    merge
                    into dbo.FENXTACCOUNTFUNDREQUIREMENT
                    using (select
                            @PDACCOUNTSYSTEMID as PDACCOUNTSYSTEMID,
                            @FUNDID as FUNDID,
                            @FUNDVALUE as FUNDVALUE,
                            @FUNDDESCRIPTION as FUNDDESCRIPTION,
                            @PROJECTREQUIREONACCOUNTSSPECIFIED as PROJECTREQUIREONACCOUNTSSPECIFIED,
                            @CHANGEAGENTID as CHANGEAGENTID,
                            @CURRENTDATE as CURRENTDATE) as source
                    on FENXTACCOUNTFUNDREQUIREMENT.FUNDID = source.FUNDID
                        and FENXTACCOUNTFUNDREQUIREMENT.PDACCOUNTSYSTEMID = source.PDACCOUNTSYSTEMID
                    when matched then
                        update
                        set FUNDVALUE = source.FUNDVALUE,
                        DESCRIPTION = source.FUNDDESCRIPTION,
                        PROJECT_REQUIREONACCOUNTSSPECIFIED = source.PROJECTREQUIREONACCOUNTSSPECIFIED,
                        CHANGEDBYID = source.CHANGEAGENTID,
                        DATECHANGED = source.CURRENTDATE
                    when not matched then
                        insert
                            (ID,
                            PDACCOUNTSYSTEMID,
                            FUNDID,
                            FUNDVALUE,
                            DESCRIPTION,
                            PROJECT_REQUIREONACCOUNTSSPECIFIED,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED)
                        values
                            (newid(),
                            source.PDACCOUNTSYSTEMID,
                            source.FUNDID,
                            source.FUNDVALUE,
                            source.FUNDDESCRIPTION,
                            source.PROJECTREQUIREONACCOUNTSSPECIFIED,
                            source.CHANGEAGENTID,
                            source.CHANGEAGENTID,
                            source.CURRENTDATE,
                            source.CURRENTDATE);