UFN_RECOGNITIONLEVEL_GETORGANIZATIONAMOUNTBYDATE

Returns the minimum amount of a recognition level in organization currency for a given date.

Return

Return Type
money

Parameters

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

Definition

Copy



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

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

            return @ORGANIZATIONAMOUNT 
        end