/* 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)