Sairam Nimmagadda

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 'PA_%API%' order by a.owner, a.name;

select u.description name,u.user_name logon, t.description, t.responsibility_name, d.start_date resp_start_date,  last_logon_date, u.creation_date, email_address from apps.fnd_user u, apps.fnd_responsibility r, apps.fnd_user_resp_groups_direct d, apps.fnd_responsibility_vl t where t.responsibility_id=d.responsibility_id and u.user_id=d.user_id and d.responsibility_id=r.responsibility_id and (t.end_date is null or t.end_date > sysdate) and (u.end_date is  null or u.end_date > sysdate) and u.description <> '1' and (d.end_date is null or d.end_date > sysdate) and upper(t.responsibility_name) like  '%PAYABLES%' order by 1,3;