USP_DATALIST_APPUSERS_FOR_ACCOUNTSYSTEM

CREATE procedure dbo.USP_DATALIST_APPUSERS_FOR_ACCOUNTSYSTEM
(
    @LOGINNAME nvarchar(50) = null,
    @USERNAME nvarchar(50) = null,
    @ACCTSYSTEMID nvarchar(36) = null
)
as
    --Used by the "Application Users" datalist
    --Returns all application users ordered by name

    select  
        APPUSER.ID,
        coalesce(APPUSER.USERNAME, '') as USERNAME,
        coalesce(APPUSER.DISPLAYNAME, '') as DISPLAYNAME,
        APPUSER.ISSYSADMIN,
        IsNull(PDACCOUNTSYSTEM.NAME, '') as PDACCOUNTSYSTEMNAME    
    from dbo.APPUSER with (nolock)
    left join dbo.APPUSERACCOUNTSYSTEM on APPUSERACCOUNTSYSTEM.APPUSERID = APPUSER.ID
    left join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.ID = APPUSERACCOUNTSYSTEM.PDACCOUNTSYSTEMID
    where 
        (@LOGINNAME is null or APPUSER.USERNAME like '%' + @LOGINNAME + '%')
        and (@USERNAME is null or APPUSER.DISPLAYNAME like '%' + @USERNAME + '%')
        and (@ACCTSYSTEMID is null or PDACCOUNTSYSTEM.ID = @ACCTSYSTEMID)
    order by APPUSER.USERNAME ASC