UFN_MEMBERSHIPLEVEL_GETBENEFITS3

Returns all benefits for a given membership level record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPLEVELID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_MEMBERSHIPLEVEL_GETBENEFITS3(@MEMBERSHIPLEVELID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    MEMBERSHIPLEVELBENEFIT.[ID], 
                    MEMBERSHIPLEVELBENEFIT.[BENEFITID], 
                    MEMBERSHIPLEVELBENEFIT.[QUANTITY], 
                    MEMBERSHIPLEVELBENEFIT.[UNITVALUE], 
                    MEMBERSHIPLEVELBENEFIT.[QUANTITY] * MEMBERSHIPLEVELBENEFIT.[UNITVALUE] as [TOTALVALUE],
                    MEMBERSHIPLEVELBENEFIT.[DETAILS], 
                    MEMBERSHIPLEVELBENEFIT.[VALUEPERCENT],
                    MEMBERSHIPLEVELBENEFIT.[SEQUENCE],
                    BENEFIT.[USEPERCENT],
                    MEMBERSHIPLEVELBENEFIT.[ORGANIZATIONUNITVALUE],
                    MEMBERSHIPLEVELBENEFIT.[ORGANIZATIONEXCHANGERATEID],
                    MEMBERSHIPLEVELBENEFIT.[BASECURRENCYID]
                from dbo.MEMBERSHIPLEVELBENEFIT 
                left join dbo.BENEFIT
                    on MEMBERSHIPLEVELBENEFIT.[BENEFITID] = BENEFIT.[ID]
                where [MEMBERSHIPLEVELID] = @MEMBERSHIPLEVELID
            )