APPS.AMS_LIST_SRC_FIELD_PVT dependencies on ALL_TAB_COLUMNS

Line 65: FROM sys.all_tab_columns

61: WHERE LIST_SOURCE_FIELD_ID = l_id;
62:
63: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
64: SELECT COLUMN_NAME
65: FROM sys.all_tab_columns
66: WHERE table_name = UPPER(p_table_name)
67: AND column_name = UPPER(p_column_name);
68:
69: CURSOR c_get_table_name(p_list_source_type_id NUMBER) IS

Line 312: FROM sys.all_tab_columns

308: WHERE list_source_field_id = p_list_source_field_id;
309:
310: CURSOR c_get_column_name(p_table_name VARCHAR2, p_column_name VARCHAR2) IS
311: SELECT COLUMN_NAME
312: FROM sys.all_tab_columns
313: WHERE table_name = UPPER(p_table_name)
314: AND column_name = UPPER(p_column_name);
315:
316: CURSOR c_get_table_name(p_list_source_type_id NUMBER) IS

Line 393: FROM sys.all_tab_columns'||'@'||l_database_link||

389: if l_remote_flag = 'Y' then
390: EXECUTE IMMEDIATE
391: 'BEGIN
392: SELECT distinct COLUMN_NAME INTO :1
393: FROM sys.all_tab_columns'||'@'||l_database_link||
394: ' WHERE table_name = UPPER( :1 )'||
395: ' AND column_name = UPPER( :2 ); END;'
396: USING l_table_name,
397: p_list_src_field_rec.source_column_name,