DBA Data[Home] [Help]

APPS.AD_ZD dependencies on FND_ORACLE_USERID

Line 129: from system.fnd_oracle_userid

125: function APPS_SCHEMA return varchar2 is
126: L_SCHEMA varchar2(30);
127: begin
128: select oracle_username into l_schema
129: from system.fnd_oracle_userid
130: where read_only_flag ='U';
131:
132: return l_schema;
133: end;

Line 143: from system.fnd_oracle_userid

139: function APPLSYS_SCHEMA return varchar2 is
140: L_SCHEMA varchar2(30);
141: begin
142: select oracle_username into l_schema
143: from system.fnd_oracle_userid
144: where read_only_flag ='E';
145:
146: return l_schema;
147: end;

Line 198: from system.fnd_oracle_userid fou, dba_users du

194: begin
195: -- test if this is an editioned database, do nothing if not.
196: select du.editions_enabled
197: into l_editions_enabled
198: from system.fnd_oracle_userid fou, dba_users du
199: where fou.read_only_flag = 'U'
200: and du.username = fou.oracle_username;
201:
202: return l_editions_enabled;