USP_DATALIST_REGISTRATIONOPTION

CREATE PROCEDURE USP_DATALIST_REGISTRATIONOPTION
(
      @EVENTID uniqueidentifier = null,
      @CONSTITUENTID uniqueidentifier = null
)
AS
set nocount on;

select EVENTPRICE.ID,
EVENTPRICE.NAME,
FAF.DESCRIPTION,
EVENTPRICE.AMOUNT,
dbo.UDA_BUILDLIST(BENEFIT.NAME) as BENEFITS,
FAF.ISREGTYPEAVAILABLEINDIVIDUAL, FAF.ISREGTYPEAVAILABLEFAMILYMEMBER, FAF.ISREGTYPEAVAILABLEHEADHOUSEHOLD, 
FAF.ISREGTYPEAVAILABLETEAMMEMBER, FAF.ISREGTYPEAVAILABLETEAMLEADER, FAF.ISREGTYPEAVAILABLECOMPANYLEADER, 
CASE WHEN FAF.MAXQUANTITY > 0 THEN CAST(FAF.MAXQUANTITY AS nvarchar(20)) ELSE 'Unlimited' END as NUMBERAVAILABLE,
FAF.ISACTIVE
from dbo.EVENTPRICE (nolock)
join dbo.FAFREGISTRATIONTYPE FAF (nolock) on EVENTPRICE.ID = FAF.EVENTPRICEID
left join dbo.EVENTPRICEBENEFIT (nolock) on FAF.EVENTPRICEID = EVENTPRICEBENEFIT.EVENTPRICEID
left join dbo.BENEFIT (nolock) on BENEFIT.ID = EVENTPRICEBENEFIT.BENEFITID
inner join dbo.REGISTRANTREGISTRATION(nolock) on REGISTRANTREGISTRATION.EVENTPRICEID= EVENTPRICE.ID
inner join dbo.REGISTRANT(nolock) on  REGISTRANT.ID = REGISTRANTREGISTRATION.REGISTRANTID
where EVENTPRICE.EVENTID = @EVENTID and REGISTRANT.ConstituentID=@CONSTITUENTID
and FAF.ISACTIVE = 1
group by EVENTPRICE.ID, EVENTPRICE.NAME,FAF.DESCRIPTION,EVENTPRICE.AMOUNT, 
FAF.ISREGTYPEAVAILABLEINDIVIDUAL, FAF.ISREGTYPEAVAILABLEFAMILYMEMBER, FAF.ISREGTYPEAVAILABLEHEADHOUSEHOLD, 
FAF.ISREGTYPEAVAILABLETEAMMEMBER, FAF.ISREGTYPEAVAILABLETEAMLEADER, FAF.ISREGTYPEAVAILABLECOMPANYLEADER, 
FAF.MAXQUANTITY, FAF.ISACTIVE