USP_SIMPLEDATALIST_FAFPROGRAM_2

CREATE procedure dbo.USP_SIMPLEDATALIST_FAFPROGRAM_2
(
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
        Select ID as VALUE, Name As LABEL 
          From dbo.FAFPROGRAM
  -- site security

  where (
    ISACTIVE = 1
    and
    exists
    (
      select 1 from UFN_SITEID_MAPFROM_FAFPROGRAMID(FAFPROGRAM.ID) FAFPROGRAMSITE
      where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[FAFPROGRAMSITE].[SITEID] or (SITEID is null and [FAFPROGRAMSITE].[SITEID] is null)))
    )
  )
          Order by name