APPS.JAI_CMN_MTAX_PKG dependencies on V$PROCESS

Line 312: FROM v$session a, v$process b

308: || Start of bug 4517919
309: */
310: CURSOR get_audsid IS
311: SELECT a.sid, a.serial#, b.spid
312: FROM v$session a, v$process b
313: WHERE audsid = userenv('SESSIONID')
314: AND a.paddr = b.addr;
315:
316: CURSOR get_dbname IS SELECT name FROM v$database;

Line 320: v_spid v$process.spid%type;

316: CURSOR get_dbname IS SELECT name FROM v$database;
317:
318: v_sid v$session.sid%type;
319: v_serial v$session.serial#%type;
320: v_spid v$process.spid%type;
321: v_name1 v$database.name%type;
322:
323: /*
324: || End of bug 4517919