APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on DBA_TAB_COLUMNS

Line 188: FROM dba_tab_columns dtc, user_synonyms syn

184: IF flag(i) = 1 THEN
185: BEGIN
186: SELECT 100 - (NVL(dtc.num_distinct,1)*100/v_cardinality)
187: INTO o_sel(i)
188: FROM dba_tab_columns dtc, user_synonyms syn
189: WHERE syn.synonym_name = UPPER(p_table_name)
190: AND dtc.owner = syn.table_owner
191: AND dtc.table_name = syn.table_name
192: AND dtc.column_name = UPPER(v_colname(i));