APPS.HZ_ELOCATION_PKG dependencies on ALL_INDEXES

Line 1805: FROM sys.all_indexes

1801: 'PARAMETERS(''sdo_commit_interval=' ||
1802: g_commit_interval || ''')';
1803: CURSOR c_index (x_index_owner IN VARCHAR2) IS
1804: SELECT status, domidx_opstatus
1805: FROM sys.all_indexes
1806: WHERE index_name = 'HZ_LOCATIONS_N15' and owner = x_index_owner;
1807: /* Fix perf bug 4956727
1808: CURSOR c_policies IS
1809: SELECT object_owner, object_name, policy_name

Line 1826: l_status sys.all_indexes.status%type;

1822: l_owners t_namelist;
1823: l_objects t_namelist;
1824: l_policies t_namelist;
1825: str varchar2(1000);
1826: l_status sys.all_indexes.status%type;
1827: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;
1828: x_dummy BOOLEAN;
1829: x_status varchar2(30);
1830: x_ind varchar2(30);

Line 1827: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;

1823: l_objects t_namelist;
1824: l_policies t_namelist;
1825: str varchar2(1000);
1826: l_status sys.all_indexes.status%type;
1827: l_domidx_opstatus sys.all_indexes.DOMIDX_OPSTATUS%type;
1828: x_dummy BOOLEAN;
1829: x_status varchar2(30);
1830: x_ind varchar2(30);
1831: x_index_owner varchar2(50);