APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on ALL_TABLES

Line 46: select owner from sys.all_tables

42: l_owner VARCHAR2(30);
43: l_view_name VARCHAR2(200);
44:
45: cursor c_view_exists(c_view_name VARCHAR2) is
46: select owner from sys.all_tables
47: where table_name = c_view_name;
48:
49: BEGIN
50: IF NVL(FND_PROFILE.VALUE('AMS_ENABLE_RECALC_AND_PREVIEW'), 'N') = 'Y'

Line 260: select 'Y' from sys.all_tables where table_name = l_view_name;

256: and qtemp.template_id = alias.template_id
257: and qtemp.list_src_type = types.source_type_code);
258:
259: cursor c_view_exists is
260: select 'Y' from sys.all_tables where table_name = l_view_name;
261:
262: l_synonym_exists varchar2(1);
263: cursor c_synonym_exists is
264: select 'Y' from sys.all_objects

Line 1085: l_check_table_string := 'begin select 1 into :l_exist from sys.all_tables'||'@'||l_dblink||' where table_name = '''||l_view_name||''' ;end;';

1081: retcode:= 0;
1082: -- SOLIN, Bug 3696553
1083: -- IF part is very up above
1084: ELSE
1085: l_check_table_string := 'begin select 1 into :l_exist from sys.all_tables'||'@'||l_dblink||' where table_name = '''||l_view_name||''' ;end;';
1086: Ams_Utility_Pvt.Write_Conc_log('l_check_table_string = '||l_check_table_string);
1087:
1088: BEGIN
1089: execute immediate l_check_table_string using OUT l_exist;