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

Query user_policies

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>