USP_DATALIST_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSPROGRAMS

      CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSPROGRAMS
      (
       @PROCESSPROGRAMSCODE tinyint = 0
      )
      as
          set nocount on;

        if @PROCESSPROGRAMSCODE = 0
        begin
          select MEMBERSHIPPROGRAM.ID from dbo.MEMBERSHIPPROGRAM
          where MEMBERSHIPPROGRAM.ISACTIVE = 1
          and (MEMBERSHIPPROGRAM.PROGRAMBASEDONCODE = 1 or MEMBERSHIPPROGRAM.PROGRAMBASEDONCODE = 2)
        end