UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES_3

            CREATE function dbo.UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES_3
            (
                @EVENTID uniqueidentifier,
                @MAINEVENTID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    REGISTRATIONPACKAGE.ID,
                    REGISTRATIONPACKAGE.NAME,
                    EVENTPRICE.ID [EVENTPRICEID],
                    EVENTPRICE.EVENTID [EVENTPRICEEVENTID],
                    PRICESEVENT.NAME [EVENTNAME],
                    EVENTPRICE.EVENTREGISTRATIONTYPEID,
                    EVENTREGISTRATIONTYPE.DESCRIPTION [EVENTREGISTRATIONTYPEDESCRIPTION],
                    EVENTPRICE.AMOUNT,
                    EVENTPRICE.RECEIPTAMOUNT,
                    EVENTPRICE.COST,
                    EVENTPRICE.REGISTRATIONCOUNT,
                    case when REGISTRATIONPACKAGES.ID is null then 0 else 1 end [SHOWPACKAGE]
                from
                    dbo.REGISTRATIONPACKAGE
                    inner join dbo.EVENT RELATEDEVENTS on RELATEDEVENTS.ID = REGISTRATIONPACKAGE.EVENTID
                    left join dbo.REGISTRATIONPACKAGEPRICE on REGISTRATIONPACKAGE.ID = REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID
                    left join dbo.EVENTPRICE on REGISTRATIONPACKAGEPRICE.EVENTPRICEID = EVENTPRICE.ID
                    left join dbo.EVENTREGISTRATIONTYPE on EVENTPRICE.EVENTREGISTRATIONTYPEID = EVENTREGISTRATIONTYPE.ID
                    left join dbo.EVENT PRICESEVENT on EVENTPRICE.EVENTID = PRICESEVENT.ID
                    left join dbo.UFN_REGISTRATIONPACKAGE_GETEVENTPACKAGES(@EVENTID, @MAINEVENTID, @CURRENTAPPUSERID) REGISTRATIONPACKAGES on REGISTRATIONPACKAGES.ID = REGISTRATIONPACKAGE.ID
                where
                    RELATEDEVENTS.MAINEVENTID = @MAINEVENTID or RELATEDEVENTS.ID = @MAINEVENTID
            )