USP_DATALIST_MEMBERSHIPLEVELBENEFIT

Displays the list of benefits for a membership level.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_MEMBERSHIPLEVELBENEFIT
            (
                @MEMBERSHIPLEVELID uniqueidentifier
            )
            as
            set nocount on;

            select 
                MLB.ID,
                BENEFIT.NAME,
                MLB.QUANTITY,
                MLB.UNITVALUE,
                (MLB.QUANTITY * MLB.UNITVALUE) AS [TOTALVALUE],
                MLB.DETAILS,
                MLB.SEQUENCE,
                MLB.BENEFITID,
                MLB.VALUEPERCENT,
                MLB.BASECURRENCYID
            from dbo.MEMBERSHIPLEVELBENEFIT MLB
            inner join dbo.BENEFIT on MLB.BENEFITID = BENEFIT.ID
            where 
            MLB.MEMBERSHIPLEVELID = @MEMBERSHIPLEVELID

            order by MLB.SEQUENCE asc