APPS.GMA_PURGE_DDL dependencies on USER_INDEXES

Line 815: , user_indexes UIX

811: , UIX.pct_free pct_free
812: , UIC.table_name indexed_column_table
813: , UIC.column_name column_name
814: from user_ind_columns UIC
815: , user_indexes UIX
816: where UIC.index_name = UIX.index_name
817: and UIX.table_name = c_table_name
818: order by UIX.index_name
819: , UIC.column_position;

Line 822: l_current_idx user_indexes.index_name%TYPE := NULL;

818: order by UIX.index_name
819: , UIC.column_position;
820:
821: -- The name of the current index
822: l_current_idx user_indexes.index_name%TYPE := NULL;
823:
824: -- These variables hold text fragments during index create statement
825: -- construction
826: l_sqlstatement user_source.text%TYPE := NULL;