CHECK FOR USER ROLE

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;