USP_DATALIST_MEMBERSHIPPROGRAMLEVELINFO

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMLEVELINFO(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    SELECT 
      ML.NAME,
      ML.[DESCRIPTION],
      MLT.AMOUNT,
      ML.MEMBERSALLOWED as MEMBERCOUNT,
      ML.CARDSALLOWED,
      ML.CHILDRENALLOWED,
      TC.DESCRIPTION as TIER,
      CASE WHEN ML.FORCEMANUALDOWNGRADES = 0 THEN 'No' ELSE 'Yes' END as FORCEMANUALDOWNGRADES

  FROM dbo.MEMBERSHIPPROGRAM MP
  INNER JOIN dbo.MEMBERSHIPLEVEL ML on MP.ID = ML.MEMBERSHIPPROGRAMID
   INNER JOIN dbo.MEMBERSHIPLEVELTERM MLT on ML.ID = MLT.LEVELID
  LEFT OUTER JOIN dbo.TIERCODE TC on ML.TIERCODEID = TC.ID
  WHERE MP.ID = @CONTEXTID