/* User Roles */
SELECT ro.ROLE_ID,
	   ro.ROLE_NAME,
	   ro.COMMENTS
  FROM ROLES ro,
  	   USER_ROLES ur
 WHERE ur.ROLE_ID = ro.ROLE_ID
   AND ur.USER_ID = :USER_ID
   AND ro.APP_ID = :APP_ID	
 ORDER BY UPPER(ro.ROLE_NAME)    