UFN_REGISTRANT_GETREGISTRATIONBENEFITS

create function dbo.UFN_REGISTRANT_GETREGISTRATIONBENEFITS(@REGISTRANTID uniqueidentifier)
returns table
as
return (
  select
    ID,
    BENEFITID,
    QUANTITY,
    UNITVALUE,
    TOTALVALUE,
    DETAILS,
    BASECURRENCYID,
    BASEEXCHANGERATEID,
    ORGANIZATIONEXCHANGERATEID,
    EVENTBASECURRENCYTOTALVALUE,
    ORGANIZATIONTOTALVALUE
  from
    dbo.REGISTRANTBENEFIT
  where
    REGISTRANTID = @REGISTRANTID
    and BENEFITTYPECODE = 0
)