Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
17 rsolanki 1 
/* User Roles */
2 
SELECT ro.ROLE_ID,
3 
	   ro.ROLE_NAME,
4 
	   ro.COMMENTS
5 
  FROM ROLES ro,
6 
  	   USER_ROLES ur
7 
 WHERE ur.ROLE_ID = ro.ROLE_ID
8 
   AND ur.USER_ID = :USER_ID
9 
   AND ro.APP_ID = :APP_ID
10 
 ORDER BY UPPER(ro.ROLE_NAME)