Subversion Repositories DevTools

/* Role Members */
SELECT DECODE( usr.IS_DISABLED,
                           NULL, 'LIMG_USER', 'LIMG_USER_DISABLED' ) AS user_image,
           usr.USER_ID,
           usr.full_name,
           usr.user_name
  FROM USERS usr,
       USER_ROLES ur
 WHERE ur.USER_ID = usr.USER_ID
   AND ur.ROLE_ID = :ROLE_ID
ORDER BY UPPER(usr.full_name)