FIND API SCRIPT

select substr(a.OWNER,1,20)
     , substr(a.NAME,1,30)
     , substr(a.TYPE,1,20)
     , substr(u.status,1,10) Stat
     , u.last_ddl_time
     , substr(text,1,80) Description
from dba_source  a,
     dba_objects u
WHERE 2=2
       and u.object_name = a.name
       and a.text like '%Header%'
       and a.type = u.object_type
       and a.name like 'HR_COM%API%'
       order by
               a.owner, a.name;