Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Application Roles */
2 
SELECT 'Role_General.asp' AS file_name,
3 
	   'IMG_ROLE' AS item_image,
4 
	   ro.ROLE_ID AS item_id,
5 
	   ro.ROLE_NAME AS item_name,
6 
	   'role_id='|| ro.role_id AS param
7 
  FROM ROLES ro
8 
 WHERE ro.APP_ID = :APP_ID
9 
   AND ro.IS_ROLE_VARIATION IS NULL
10 
ORDER BY UPPER(ro.ROLE_NAME)
11