SYSTEM.AD_APPS_PRIVATE dependencies on DUAL

Line 32: x_edition_type || ''') from dual' into l_edition;

28: FROM fnd_oracle_userid
29: WHERE read_only_flag='U';
30:
31: execute immediate 'select ' || l_apps_schema || '.ad_zd.get_edition(''' ||
32: x_edition_type || ''') from dual' into l_edition;
33:
34: return l_edition;
35: exception
36: WHEN OTHERS THEN

Line 96: stmt := 'select ' ||l_apps_schema||'.AD_ZD_TABLE.EV_VIEW('''||p_obj_name||''') from DUAL';

92: INTO l_apps_schema
93: FROM fnd_oracle_userid
94: WHERE read_only_flag='U';
95:
96: stmt := 'select ' ||l_apps_schema||'.AD_ZD_TABLE.EV_VIEW('''||p_obj_name||''') from DUAL';
97: DBMS_SQL.PARSE(CUR, STMT, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN (CUR, 1, l_evname, 30);
99: IGN := DBMS_SQL.execute(CUR);
100: LOOP

Line 1939: From dual;

1935: Where ds.table_owner= upper(base_schema)
1936: And ds.table_name = rtrim(Syn_Rec.object_Name);
1937: ELSE
1938: Select rtrim(Syn_Rec.object_Name) into syn_name
1939: From dual;
1940: END IF;
1941: -- End finding the synonym name for each object_name
1942: -- create the synonyms
1943: create_synonym(p_from_schema_name => base_schema,

Line 2440: statement := 'select null from sys.dual where 1 = 2 '||

2436: 'and nvl(atc.enabled_flag,''Y'') = ''Y'' '||
2437: 'and dt.owner = :table_schema ';
2438: else
2439: -- therefore there are no special views to be created
2440: statement := 'select null from sys.dual where 1 = 2 '||
2441: 'and :table_schema = ''X'' ';
2442: end if;
2443:
2444:

Line 4314: execute immediate 'select '||l_apps_schema||'.ad_zd.get_edition_type from dual'

4310: SELECT oracle_username
4311: INTO l_apps_schema
4312: FROM fnd_oracle_userid
4313: WHERE read_only_flag='U';
4314: execute immediate 'select '||l_apps_schema||'.ad_zd.get_edition_type from dual'
4315: into l_edition_type;
4316: if l_edition_type = 'PATCH' then
4317: --Action on patch edition performed by calling function. Return
4318: return;