APPS.ETRM_PNAV dependencies on DBA_INDEXES

Line 796: cursor cur_index(cv_tab_name in dba_indexes.table_name%type

792: and table_name = c_name
793: and (table_type = 'TABLE'
794: OR table_type = 'VIEW');
795:
796: cursor cur_index(cv_tab_name in dba_indexes.table_name%type
797: , c_owner in dba_objects.owner%type)
798: -- List Indexes
799: is select ind.index_name
800: , ind.index_type

Line 806: from dba_indexes ind

802: , ind.tablespace_name
803: , ind.pct_increase
804: , ind.pct_free
805: , ind.owner
806: from dba_indexes ind
807: where ind.table_name = cv_tab_name
808: and ind.table_owner = c_owner
809: order by ind.uniqueness desc, ind.index_name;
810: --

Line 1244: FROM SYS.DBA_INDEXES

1240: , c_owner in dba_objects.owner%type) is
1241: SELECT TABLE_OWNER
1242: , TABLE_TYPE
1243: , TABLE_NAME
1244: FROM SYS.DBA_INDEXES
1245: where OWNER = c_owner
1246: and INDEX_NAME = c_name;
1247:
1248: begin