Oracle PL/SQL Tutorial/System Tables Data Dictionary/user policies

Query user_policies

   <source lang="sql">

SQL> SQL> column pf_owner format a10 SQL> column package format a10 SQL> column function format a10 SQL> select pf_owner, package, function

 2    from user_policies a
 3   where exists ( select null
 4                    from all_objects
 5                   where owner = pf_owner
 6                     and object_type in ( "FUNCTION", "PACKAGE",
 7                                          "PACKAGE BODY" )
 8                     and status = "INVALID"
 9                    and object_name in ( a.package, a.function )
10                )
11  /

no rows selected SQL> SQL></source>