USP_DATALIST_RECOGNITIONLEVELAMOUNT

Displays a list of minimum amounts for a recognition level.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONLEVELID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_RECOGNITIONLEVELAMOUNT(@RECOGNITIONLEVELID uniqueidentifier)
            as
                set nocount on;

                select ID,
                    AMOUNT,
                    ACTIVEDATE,
                    dbo.UFN_RECOGNITIONLEVELAMOUNT_EXISTSIMILARRECOGNITIONLEVEL(ID) as ALLOWDELETE,
                    BASECURRENCYID
                from dbo.RECOGNITIONLEVELAMOUNT
                where RECOGNITIONLEVELID = @RECOGNITIONLEVELID    
                order by ACTIVEDATE desc