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
)