UFN_EVENTPRICEBENEFIT_GETMULTICOMPONENTEVENTPRICEBENEFITS

            CREATE function dbo.UFN_EVENTPRICEBENEFIT_GETMULTICOMPONENTEVENTPRICEBENEFITS
            (
                @EVENTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    EVENTPRICEBENEFIT.ID [EVENTPRICEBENEFITID],
                    BENEFIT.ID [BENEFITID],
                    BENEFIT.NAME [BENEFITNAME],
                    BENEFIT.DESCRIPTION [BENEFITDESCRIPTION],
                    EVENTPRICEBENEFIT.EVENTBASECURRENCYTOTALVALUE [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 = @EVENTID
                    or EVENT.MAINEVENTID = @EVENTID
            )