Query user_policies : user_policies « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. 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>