/* Role List */
SELECT ro.role_id,
	   ro.ROLE_NAME,
	   ro.COMMENTS
  FROM ROLES ro
 WHERE ro.IS_ROLE_VARIATION IS NULL
   AND ro.app_id = :APP_ID
ORDER BY UPPER(ro.role_name)
   