APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on ALL_INDEXES

Line 93: FROM ALL_INDEXES

89: -- Check owner name for the tables and indexes.
90: BEGIN
91: SELECT owner, table_owner, tablespace_name
92: INTO l_index_owner, l_table_owner, l_index_tblspace
93: FROM ALL_INDEXES
94: WHERE TABLE_NAME = 'JTF_RS_DBI_DENORM_RES_GROUPS'
95: AND index_name = 'JTF_RS_DBI_DENORM_RES_GRPS_N1'
96: AND table_owner= l_jtfu;
97:

Line 107: FROM ALL_INDEXES

103:
104: -- Check some ther index which will definitly exist
105: SELECT owner, table_owner, tablespace_name
106: INTO l_index_owner, l_table_owner, l_index_tblspace
107: FROM ALL_INDEXES
108: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
109: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
110: AND table_owner= l_jtfu;
111: END;