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;