/* Application User List*/
SELECT 'User_General.asp' AS file_name,
	   DECODE ( usr.IS_DISABLED,
	   		  	NULL, 'IMG_USER',
				'IMG_USER_DISABLED' ) AS item_image,
	   usr.user_id AS item_id,
	   usr.full_name ||' ['|| usr.user_name ||']' AS item_name,
	   'user_id='|| usr.user_id AS param
  FROM USERS usr,
  	   USER_APPLICATIONS usra
 WHERE usra.USER_ID = usr.USER_ID 
   AND usra.APP_ID = :APP_ID
ORDER BY UPPER(usr.FULL_NAME)