UFN_EVENTPRICE_GETBENEFITS_2

Returns all members for a given event price.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@EVENTPRICEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_EVENTPRICE_GETBENEFITS_2(
                @EVENTPRICEID uniqueidentifier
            )
            returns table
            as
            return (
                select
                    EVENTPRICEBENEFIT.ID,
                    EVENTPRICEBENEFIT.BENEFITID,
                    EVENTPRICEBENEFIT.UNITVALUE,
                    EVENTPRICEBENEFIT.QUANTITY,
                    EVENTPRICEBENEFIT.TOTALVALUE,
                    EVENTPRICEBENEFIT.DETAILS,
                    EVENTPRICEBENEFIT.BASECURRENCYID,
                    EVENTPRICEBENEFIT.BASEEXCHANGERATEID,
                    EVENTPRICEBENEFIT.ORGANIZATIONEXCHANGERATEID,
                    EVENTPRICEBENEFIT.EVENTBASECURRENCYTOTALVALUE,
                    EVENTPRICEBENEFIT.ORGANIZATIONTOTALVALUE
                from
                    dbo.EVENTPRICEBENEFIT
                where
                    EVENTPRICEID = @EVENTPRICEID
            )