Des/2000: SQL that return PL/SQL block of one module

I need a report that gives me all the modules from CASE (Designer/2000) and PL/SQL block of this module ( declared as trigger od procedure or function) that have in this PL/SQL block string that is given as parameter.

On the other words, i need a list of triggers and their PL/SQL block (DECLARE ... BEGIN ... END;) that have cursor named CUSTOMER_CUR.

This SQL will be something like (connected as CASE user):

SELECT master.el_short_name
, detail.????
FROM ci_modules master,
????? detail
WHERE master.id = detail.????

I have a lot of reports that gives me release notes for modules that are not yet finisher, ...

I'm getting frustrated becuse I can't find tables and relations between them to find a PL/SQL block for a given module.

If someone has any information that will help me with this problemm, please replay on this message. Received on Thu Sep 10 1998 - 21:49:46 CEST