Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Role List */
2 
SELECT ro.role_id,
3 
	   ro.ROLE_NAME,
4 
	   ro.COMMENTS
5 
  FROM ROLES ro
6 
 WHERE ro.IS_ROLE_VARIATION IS NULL
7 
   AND ro.app_id = :APP_ID
8 
ORDER BY UPPER(ro.role_name)
9