APPS.AMS_LISTSOURCETYPE_PVT dependencies on ALL_TAB_COLUMNS

Line 1673: -- FROM sys.all_tab_columns

1669: L_DEFAULT_NUM_BUCKETS CONSTANT NUMBER := 10;
1670:
1671: -- CURSOR c_source (p_source_name IN VARCHAR2, p_pk IN VARCHAR2) IS
1672: -- SELECT DISTINCT column_name, data_type
1673: -- FROM sys.all_tab_columns
1674: -- WHERE table_name = p_source_name
1675: -- AND column_name <> p_pk
1676: -- AND data_type IN ('NUMBER', 'VARCHAR2')
1677: -- ;

Line 1682: FROM sys.all_tab_columns

1678:
1679: -- Modified by nyostos on Jan 27, 2003 to remove condition that field is not the primary key
1680: CURSOR c_source (p_source_name IN VARCHAR2) IS
1681: SELECT DISTINCT column_name, data_type
1682: FROM sys.all_tab_columns
1683: WHERE table_name = p_source_name
1684: AND data_type IN ('NUMBER', 'VARCHAR2')
1685: ;
1686: