USP_DATALIST_MEMBERSHIPPROGRAMLEVELSADDON

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

                declare @MPADDONID uniqueidentifier;
                SELECT
                    MPA.ID,
                    A.NAME,
                    A.ADDONTYPE,                    
                    MPA.DESCRIPTION,
                    MPA.PRICE,
                    CASE WHEN MPA.MULTIPLEALLOWED = 0 THEN 'No' ELSE 'Yes' END MULTIPLEALLOWED,
                    MP.BASECURRENCYID
              FROM dbo.MEMBERSHIPPROGRAM MP
              INNER JOIN dbo.MEMBERSHIPPROGRAMADDON MPA on MP.ID = MPA.MEMBERSHIPPROGRAMID
              INNER JOIN dbo.ADDON A on MPA.ADDONID = A.ID    
              where MP.ID = @CONTEXTID