USP_DATALIST_PROGRAMGROUPSELECTIONPROGRAM

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

        select ID,
              dbo.UFN_PROGRAM_GETNAME(ID) as NAME
        from (select PROGRAM.ID as ID
              from dbo.UFN_IDSETREADER_GETRESULTS_GUID(@CONTEXTID) as SELECTIONRESULT
              inner join dbo.PROGRAM on PROGRAM.ID = SELECTIONRESULT.ID
              where PROGRAM.ISPREREGISTERED = 0
        ) as SELECTION
    order by NAME