USP_FAFPLEDGERECOGNITIONUPDATE

create procedure dbo.USP_FAFPLEDGERECOGNITIONUPDATE
(
    @REVENUEID uniqueidentifier,
    @RECOGNITIONCONSTITUENTID uniqueidentifier  -- participant / team constituentid

)
as
begin

    DECLARE @REVENUESPLITID uniqueidentifier

    SELECT @REVENUESPLITID = RS.ID
    FROM dbo.REVENUE R (NOLOCK)
    INNER JOIN dbo.REVENUESPLIT RS (NOLOCK)
    ON R.ID = RS.REVENUEID
    where R.TRANSACTIONTYPECODE in (1,2)
    and R.ID = @REVENUEID

    UPDATE dbo.REVENUERECOGNITION
    SET CONSTITUENTID = @RECOGNITIONCONSTITUENTID
    WHERE REVENUESPLITID = @REVENUESPLITID

end