USP_DATALIST_FAFREGISTRATIONBENEFITOPTION

CREATE procedure dbo.USP_DATALIST_FAFREGISTRATIONBENEFITOPTION(@EVENTPRICEID uniqueidentifier)
as
    set nocount on;

    SELECT EB.BENEFITID,
        B.NAME as BENEFITNAME, 
        BBO.BENEFITOPTIONID, 
        BO.NAME as BENEFITOPTIONNAME,
        B.DESCRIPTION
    FROM dbo.EVENTPRICE EP (NOLOCK)
    INNER JOIN dbo.EVENTPRICEBENEFIT EB (NOLOCK)
    ON EP.ID = EB.EVENTPRICEID
    INNER JOIN dbo.BENEFIT B
    ON EB.BENEFITID = B.ID
    LEFT OUTER JOIN dbo.BENEFITBENEFITOPTION BBO (NOLOCK)
    ON B.ID = BBO.BENEFITID
    LEFT OUTER JOIN dbo.BENEFITOPTION BO (NOLOCK)
    ON BO.ID = BBO.BENEFITOPTIONID
    where EP.ID = @EVENTPRICEID