My problem is that I would like the same set of Radio Buttons to show all the choices if the user is an admin (and not if they're not)
Currently my LOV SQL is:
select ROLE_NAME display_value, ROLE_ID return_value
where ROLE_ID IN (Select ROLE_ID from PMO_ROLE_PERSON where MUID = :APP_USER)
order by ROLE_ID
So its showing the all the roles that the current user belongs to and its already changing depending on what ROLE(s) the user is in. But when the user is in the admin table (whether its in a role or 2 or not) I would like them to be able to see all the options.
I can't make a second set of radio buttons and then just hide/show one or the other when the user is an admin because I have a process based on this set (P5_ROLES)
hope that was clear enough...