APPS.ETRM_PNAV dependencies on DBA_IND_COLUMNS

Line 811: cursor cur_index_col(cv_index_name in dba_ind_columns.index_name%type

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: --
811: cursor cur_index_col(cv_index_name in dba_ind_columns.index_name%type
812: , c_owner in dba_objects.owner%type)
813: -- List index columns
814: is select ic.column_name
815: , ic.column_length

Line 816: from dba_ind_columns ic

812: , c_owner in dba_objects.owner%type)
813: -- List index columns
814: is select ic.column_name
815: , ic.column_length
816: from dba_ind_columns ic
817: where ic.index_name = cv_index_name
818: and ic.index_owner = c_owner
819: order by ic.column_position;
820:

Line 821: cursor cur_function_index(cv_index_name in dba_ind_columns.index_name%type

817: where ic.index_name = cv_index_name
818: and ic.index_owner = c_owner
819: order by ic.column_position;
820:
821: cursor cur_function_index(cv_index_name in dba_ind_columns.index_name%type
822: , c_owner in dba_objects.owner%type)
823: is SELECT COLUMN_EXPRESSION
824: FROM SYS.DBA_IND_EXPRESSIONS
825: where INDEX_OWNER = c_owner