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