UFN_EVENTPRICEBENEFIT_GETRELATEDEVENTPRICEBENEFITS

create function dbo.UFN_EVENTPRICEBENEFIT_GETRELATEDEVENTPRICEBENEFITS
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return
(
    select
        EVENTPRICEBENEFIT.ID [EVENTPRICEBENEFITID],
        BENEFIT.ID [BENEFITID],
        BENEFIT.NAME [BENEFITNAME],
        BENEFIT.DESCRIPTION [BENEFITDESCRIPTION],
        EVENTPRICEBENEFIT.TOTALVALUE [BENEFITTOTALVALUE],
        EVENTPRICEBENEFIT.DETAILS [EVENTPRICEBENEFITDETAILS],
        EVENTPRICEBENEFIT.EVENTPRICEID,
        EVENTPRICE.EVENTID [EVENTPRICEEVENTID],
        EVENTREGISTRATIONTYPE.DESCRIPTION [EVENTREGISTRATIONTYPEDESCRIPTION],
        EVENT.NAME [EVENTNAME]
    from
        dbo.EVENTPRICEBENEFIT
        inner join dbo.BENEFIT on EVENTPRICEBENEFIT.BENEFITID = BENEFIT.ID
        inner join dbo.EVENTPRICE on EVENTPRICEBENEFIT.EVENTPRICEID = EVENTPRICE.ID
        inner join dbo.EVENTREGISTRATIONTYPE on EVENTPRICE.EVENTREGISTRATIONTYPEID = EVENTREGISTRATIONTYPE.ID
        inner join dbo.EVENT on EVENTPRICE.EVENTID = EVENT.ID
    where
        EVENTPRICE.EVENTID in (select ID from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID))
)