DBA Data[Home] [Help]

APPS.FND_ODF_GEN dependencies on OBJ$

Line 56: TYPE NameTab IS TABLE OF sys.obj$.name%TYPE;

52: l_policyListing VARCHAR2(100);
53: l_indexCtr NUMBER;
54: l_sqlCond VARCHAR2(2000);
55:
56: TYPE NameTab IS TABLE OF sys.obj$.name%TYPE;
57: l_triggNames NameTab;
58: l_triggList VARCHAR2(2000);
59:
60: e_dbms_metadata_01 EXCEPTION;

Line 419: from sys.obj$ ot, sys.obj$ bo, sys.trigger$ t

415:
416: Begin
417:
418: select ot.name BULK COLLECT INTO l_triggNames
419: from sys.obj$ ot, sys.obj$ bo, sys.trigger$ t
420: where t.BASEOBJECT = bo.OBJ#
421: and bo.NAME = l_objName
422: and ot.OBJ# = t.OBJ#;
423: