UFN_REVENUE_GETREVALUATIONS

        create function dbo.UFN_REVENUE_GETREVALUATIONS
        (
            @REVENUEID uniqueidentifier
        )
        returns @REVALUATIONS table (
            [ID] uniqueidentifier,
            [SEQUENCE] int,
            [DATE] datetime,
            [BASEEXCHANGERATEID] uniqueidentifier,
            [ORGANIZATIONEXCHANGERATEID] uniqueidentifier
        )
        as
        begin

            insert into @REVALUATIONS (ID, SEQUENCE, DATE, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID)
            select
                COMMITMENTREVALUATION.ID,
                COMMITMENTREVALUATION.SEQUENCE,
                COMMITMENTREVALUATION.DATE,
                COMMITMENTREVALUATION.BASEEXCHANGERATEID,
                COMMITMENTREVALUATION.ORGANIZATIONEXCHANGERATEID
            from
                dbo.REVENUECOMMITMENTREVALUATION
                inner join dbo.COMMITMENTREVALUATION on REVENUECOMMITMENTREVALUATION.COMMITMENTREVALUATIONID = COMMITMENTREVALUATION.ID
            where
                REVENUECOMMITMENTREVALUATION.REVENUEID = @REVENUEID
            order by
                COMMITMENTREVALUATION.DATE desc, COMMITMENTREVALUATION.SEQUENCE desc;

            return;

        end