UFN_ITINERARY_GETATTENDEES

        CREATE function dbo.UFN_ITINERARY_GETATTENDEES
        (
            @ITINERARYID uniqueidentifier
        )
        returns table
        as return
            select
                ITINERARYATTENDEE.ID,
                PRICETYPECODEID,
                QUANTITY,
                ITINERARYATTENDEE.SEQUENCE
            from
                dbo.ITINERARYATTENDEE
            left join dbo.PRICETYPECODE on 
                PRICETYPECODE.ID = ITINERARYATTENDEE.PRICETYPECODEID
            inner join dbo.ITINERARY on
                ITINERARY.ID = ITINERARYATTENDEE.ITINERARYID
            where
                ITINERARYID=@ITINERARYID and
                PRICETYPECODE.ID in (select ID from dbo.UFN_RESERVATION_ALLOWEDPRICETYPES(RESERVATIONID));