Rev 2 | Blame | Compare with Previous | Last modification | View Log | RSS feed
/* Role List */ SELECT ro.role_id, ro.ROLE_NAME, ro.COMMENTS FROM ROLES ro WHERE ro.IS_ROLE_VARIATION IS NULL AND ro.app_id = :APP_ID ORDER BY UPPER(ro.role_name)
/* Role List */
SELECT ro.role_id,
ro.ROLE_NAME,
ro.COMMENTS
FROM ROLES ro
WHERE ro.IS_ROLE_VARIATION IS NULL
AND ro.app_id = :APP_ID
ORDER BY UPPER(ro.role_name)