SQL Query for List of API's in APPS

select DS.OWNER
, DS.NAME DS.TYPE
, DO.status
, DO.last_ddl_time
, DS.text Description
from dba_source DS, dba_objects DO
WHERE DO.object_name = DS.name
and DS.text like '%Header%'
and Ds.type = DO.object_type
and DS.name like UPPER(:P_API_NAME) orderby DS.name