USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_INCOMECOMPENSATION

            CREATE procedure dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_INCOMECOMPENSATION (
                @WEALTHID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null
            ) as begin
                set nocount on;

                declare @CURRENTDATE datetime;

                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                if exists (select WEALTH.ID from dbo.WEALTH where WEALTH.ID = @WEALTHID) begin
                    declare @INCOMECOMPENSATIONASSETS money, @INCOMECOMPENSATIONASSETSCONFIRMED money, @INCOMECOMPENSATIONNUMBER int, @INCOMECOMPENSATIONNUMBERCONFIRMED int;

                    select @INCOMECOMPENSATIONNUMBER = count(*), @INCOMECOMPENSATIONASSETS = sum(TOTALCOMPENSATION) from dbo.WPINCOMECOMPENSATION where WEALTHID = @WEALTHID and REJECTED = 0 and HISTORICCODE <> 1;
                    select @INCOMECOMPENSATIONNUMBERCONFIRMED = count(*), @INCOMECOMPENSATIONASSETSCONFIRMED = sum(TOTALCOMPENSATION) from dbo.WPINCOMECOMPENSATION where WEALTHID = @WEALTHID and CONFIRMED = 1 and HISTORICCODE <> 1;

                    update
                        dbo.WEALTH
                    set
                        INCOMECOMPENSATIONASSETS = coalesce(@INCOMECOMPENSATIONASSETS,0),
                        INCOMECOMPENSATIONASSETSCONFIRMED = coalesce(@INCOMECOMPENSATIONASSETSCONFIRMED,0),
                        INCOMECOMPENSATIONNUMBER = coalesce(@INCOMECOMPENSATIONNUMBER,0),
                        INCOMECOMPENSATIONNUMBERCONFIRMED = coalesce(@INCOMECOMPENSATIONNUMBERCONFIRMED,0),
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @WEALTHID;
                end
            end