UFN_RECOGNITIONLEVEL_GETORGANIZATIONEXCHANGERATEIDBYDATE

Returns the organization exchange rate of a recognition level for a given date.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONLEVELID	uniqueidentifier	IN
@DATE	datetime	IN

Definition

Copy



        create function dbo.UFN_RECOGNITIONLEVEL_GETORGANIZATIONEXCHANGERATEIDBYDATE
        (
              @RECOGNITIONLEVELID uniqueidentifier, 
              @DATE datetime
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @ORGANIZATIONEXCHANGERATEID uniqueidentifier;

            select top 1 @ORGANIZATIONEXCHANGERATEID = ORGANIZATIONEXCHANGERATEID
            from dbo.RECOGNITIONLEVELAMOUNT
            where RECOGNITIONLEVELID = @RECOGNITIONLEVELID 
                and coalesce(ACTIVEDATE, 0) <= @DATE
            order by ACTIVEDATE desc;

            return @ORGANIZATIONEXCHANGERATEID 
        end