APPS.JTF_RS_SRP_GROUPS_CONC_PUB dependencies on ALL_INDEXES

Line 166: FROM ALL_INDEXES

162: -- Check owner name for the tables and indexes.
163: BEGIN
164: SELECT owner, table_owner, tablespace_name
165: INTO l_index_owner, l_table_owner, l_index_tblspace
166: FROM ALL_INDEXES
167: WHERE TABLE_NAME = 'JTF_RS_SRP_GROUPS_INT'
168: AND index_name = 'JTF_RS_SRP_GROUPS_INT_N1'
169: AND table_owner= l_jtfu;
170:

Line 180: FROM ALL_INDEXES

176:
177: -- Check some ther index which will definitly exist
178: SELECT owner, table_owner, tablespace_name
179: INTO l_index_owner, l_table_owner, l_index_tblspace
180: FROM ALL_INDEXES
181: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
182: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
183: AND table_owner= l_jtfu;
184: END;