APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on ALL_INDEXES

Line 169: FROM ALL_INDEXES

165: -- Check owner name for the tables and indexes.
166: BEGIN
167: SELECT owner, table_owner, tablespace_name
168: INTO l_index_owner, l_table_owner, l_index_tblspace
169: FROM ALL_INDEXES
170: WHERE TABLE_NAME = 'JTF_RS_DEFAULT_GROUPS_INT'
171: AND index_name = 'JTF_RS_DEFAULT_GROUPS_INT_N1'
172: AND table_owner= l_jtfu;
173:

Line 183: FROM ALL_INDEXES

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