APPS.AD_ZD_ADOP dependencies on V$SESSION

Line 410: from v$session where audsid=USERENV('SESSIONID');

406: BEGIN
407: log(l_mod_name,'STATEMENT','START -->');
408:
409: select substr(machine, 1,decode(instr(machine, '.', 1,1),0,length(machine),instr(machine, '.', 1, 1)-1)) into l_invoking_node
410: from v$session where audsid=USERENV('SESSIONID');
411:
412: l_invoking_node := substr(l_invoking_node, instr(l_invoking_node,'\')+1);
413:
414: status_order('N'):=10;

Line 587: v$session s, v$process p, database_properties run -- /* run edition name */

583: select
584: '/* '||e.object_name||' '||s.osuser||' '||s.username||' */' info,
585: 'ALTER SYSTEM KILL SESSION '||''''||s.sid||','||s.serial#||'''' kill
586: from
587: v$session s, v$process p, database_properties run -- /* run edition name */
588: , dba_objects_ae e
589: where s.type <> 'BACKGROUND' and p.addr = s.paddr
590: and run.property_name = 'DEFAULT_EDITION'
591: and e.object_id = s.session_edition_id