APPS.CN_SCA_UTL_PVT dependencies on ALL_INDEXES

Line 101: FROM all_indexes aidx

97: GROUP BY a.src_column_name;
98:
99: CURSOR index_cur(l_table_owner VARCHAR2) IS
100: SELECT aidx.owner, aidx.index_name
101: FROM all_indexes aidx
102: WHERE aidx.table_name = 'CN_SCA_HEADERS_INTERFACE_ALL'
103: AND aidx.table_owner = l_table_owner
104: AND aidx.index_name LIKE 'CN_SCA_HEADERS_INTERFACE_A%';
105:

Line 148: debugmsg('Dropped all indexes ...');

144: debugmsg('Oracle Error: '||SQLERRM);
145: RAISE;
146: END;
147:
148: debugmsg('Dropped all indexes ...');
149:
150: --+
151: --+ Creating new indexes based on the Rule Attributes used in a given
152: --+ Transaction Source