DBA Data[Home] [Help]

APPS.FND_CP_FNDSM dependencies on DUAL

Line 212: from dual;

208:
209: if (ncount <> 0) then
210: select fnd_concurrent_queues_s.nextval
211: into dummy
212: from dual;
213:
214: mgr_name := substrb('FNDSM_'||dummy||'_'||node,
215: 1, 30);
216: end if;

Line 266: from dual;

262:
263: if (ncount <> 0) then
264: select fnd_concurrent_queues_s.nextval
265: into dummy
266: from dual;
267:
268: mgr_name := substrb('FNDIM_'||dummy||'_'||node,
269: 1, 30);
270: end if;

Line 325: from dual;

321:
322: if (ncount <> 0) then
323: select fnd_concurrent_queues_s.nextval
324: into dummy
325: from dual;
326:
327: mgr_name := substrb('OAMGCS_'||dummy||'_'||node,
328: 1, 30);
329: end if;

Line 399: from dual;

395: where name = 'db_domain';
396:
397: select userenv('SESSIONID')
398: into audsid
399: from dual;
400:
401: select p.pid
402: into opid
403: from v$process p, v$session s