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)