USP_DATALIST_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS

      CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS(@CURRENTAPPUSERID uniqueidentifier = null)
      as
          set nocount on;

                    set nocount on;
                    select
                        MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.ID, 
                        MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.NAME, 
                        MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.DESCRIPTION,
            case MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMSCODE
            when 0 then MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMS
            when 1 then MP.NAME
            else MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMS
            end,
                        BPI.OWNERID as OWNERID
                    from dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
          left join dbo.MEMBERSHIPPROGRAM MP on MP.ID  = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.MEMBERSHIPPROGRAMID
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.ID) = 1)

                    order by
                        MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.DATEADDED;