/* Application Roles */
SELECT 'Role_General.asp' AS file_name,
	   'IMG_ROLE' AS item_image,
	   ro.ROLE_ID AS item_id,
	   ro.ROLE_NAME AS item_name,
	   'role_id='|| ro.role_id AS param
  FROM ROLES ro
 WHERE ro.APP_ID = :APP_ID
   AND ro.IS_ROLE_VARIATION IS NULL
ORDER BY UPPER(ro.ROLE_NAME)

