USP_REVENUELETTER_SETREACKNOWLEDGEMENTS

            CREATE procedure dbo.USP_REVENUELETTER_SETREACKNOWLEDGEMENTS
            (
                @REVENUEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

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

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate();

                if (coalesce((select top 1 REACKNOWLEDGEREVENUE from dbo.ACKNOWLEDGEMENTPREFERENCE), 0)) = 1
                    update
                        dbo.REVENUELETTER
                    set
                        REVENUELETTER.OUTOFDATE = 1,
                        REVENUELETTER.CHANGEDBYID = @CHANGEAGENTID, 
                        REVENUELETTER.DATECHANGED = @CHANGEDATE
                    where
                        REVENUELETTER.REVENUEID = @REVENUEID
                        and (REVENUELETTER.PROCESSDATE is not null or REVENUELETTER.ACKNOWLEDGEDATE is not null)
                        and OUTOFDATE = 0;

                return 0;