USP_DATALIST_MEMBERSHIPPROGRAM_CMS

      create procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAM_CMS
            (
                @CURRENTAPPUSERID uniqueidentifier = null,
                @INCLUDEINACTIVE bit = 0,
                @SITEFILTERMODE tinyint = 0,
                @SITESSELECTED xml = null,
                @SECURITYFEATUREID uniqueidentifier = null,
                @SECURITYFEATURETYPE tinyint = null
            )
      as
          set nocount on;

        declare @ALLMEMBERSHIPPROGAMS table
        (
          ID uniqueidentifier not null,
          NAME nvarchar(100) not null,
          DESCRIPTION nvarchar(255) not null,
          SITE nvarchar(500),
          EXPIRESON nvarchar(40) not null,
            ALLOWMULTIPLEMEMBERSHIPS bit not null,
            ISACTIVE bit not null,
            CUTOFFDAY int not null,
            CUTOFFDATEFORYEAR UDT_MONTHDAY not null,
            EXPIRESONCODE int not null,
          BASECURRENCYID uniqueidentifier null,
          ALLOWADDONADULT bit,
          ADDONADULTPRICE money,
          ALLOWADDONGUEST bit,
          ADDONGUESTPRICE money,
          CONTRIBUTIONBASEDEXPIRESONCODE int,
          PROGRAMTYPECODE int not null,
          PROGRAMBASEDONCODE int not null
        )

        INSERT @ALLMEMBERSHIPPROGAMS
        EXECUTE USP_DATALIST_MEMBERSHIPPROGRAM @CURRENTAPPUSERID, @INCLUDEINACTIVE, @SITEFILTERMODE, @SITESSELECTED, @SECURITYFEATUREID, @SECURITYFEATURETYPE

        select
          ID,
          NAME,
          DESCRIPTION,
          SITE,
          ALLOWMULTIPLEMEMBERSHIPS,
          ISACTIVE,
          BASECURRENCYID
        from 
          @ALLMEMBERSHIPPROGAMS
        where
          PROGRAMTYPECODE = 0 AND
          PROGRAMBASEDONCODE = 0;