begin IF APEX_ACL.HAS_USER_ROLE (p_role_static_id => 'ADMINISTRATOR' ) THEN return 'select * from ASSESSMENT_PLANS'; ELSIF APEX_ACL.HAS_USER_ROLE (p_role_static_id => 'MANAGER' ) THEN return 'select * from ASSESSMENT_PLANS where PROGRAM_MANAGER ='|| APEX_CUSTOM_AUTH.GET_USERNAME ||'; else return 'select * from ASSESSMENT_PLANS where ASSGINED_TO = '|| APEX_CUSTOM_AUTH.GET_USERNAME ||' AND STATUS = '''PENDING'''; end if; end;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter