DBA Data[Home] [Help]

APPS.HZ_SEED_CLASS_CAT_PKG dependencies on DBA_TAB_COLUMNS

Line 22: , dba_tab_columns col

18: CURSOR c1(l_schema IN VARCHAR2) IS
19: select 'Y'
20: from
21: user_synonyms syn
22: , dba_tab_columns col
23: where syn.synonym_name = 'HZ_CLASS_CATEGORIES'
24: and col.owner = syn.table_owner
25: and col.table_name = syn.table_name
26: and col.column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG';

Line 173: , dba_tab_columns col

169: CURSOR c1(l_schema IN VARCHAR2) IS
170: select 'Y'
171: from
172: user_synonyms syn
173: , dba_tab_columns col
174: where syn.synonym_name = 'HZ_CLASS_CATEGORY_USES'
175: and col.owner = syn.table_owner
176: and col.table_name = syn.table_name
177: and col.column_name = 'ADDITIONAL_WHERE_CLAUSE';