DBA Data[Home] [Help]

APPS.FND_ADG_UTILITY dependencies on V$PROCESS

Line 534: from v$session a,v$process b

530: p_trace_error number)
531: as
532: PRAGMA AUTONOMOUS_TRANSACTION;
533: cursor c1 is select b.pid,b.spid,a.audsid,a.process
534: from v$session a,v$process b
535: where a.sid = ( select distinct c.sid from v$mystat c)
536: and a.paddr = b.addr;
537:
538: begin

Line 1401: ' from v$session a,v$process b ' ||

1397: begin
1398:
1399: execute immediate
1400: 'select b.tracefile ' ||
1401: ' from v$session a,v$process b ' ||
1402: ' where a.sid = ( select distinct c.sid from v$mystat c) ' ||
1403: ' and a.paddr = b.addr'
1404: into l_tracefile;
1405: