USP_DATALIST_RECOGNITIONLEVELBENEFIT

Displays the list of benefits 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_RECOGNITIONLEVELBENEFIT(@RECOGNITIONLEVELID uniqueidentifier)
                as
                    set nocount on;

                    select RLB.ID,
                           BENEFIT.NAME,
                           RLB.QUANTITY,
                           RLB.UNITVALUE,
                           (RLB.QUANTITY * RLB.UNITVALUE) AS [TOTALVALUE],
                           RLB.DETAILS,
                           RLB.BASECURRENCYID
                    from dbo.RECOGNITIONLEVELBENEFIT RLB
                    inner join dbo.BENEFIT on RLB.BENEFITID = BENEFIT.ID
                    where RLB.RECOGNITIONLEVELID = @RECOGNITIONLEVELID
                    order by RLB.SEQUENCE asc