APPS.JAI_CMN_MTAX_PKG dependencies on V$PROCESS

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

267: || Start of bug 4517919
268: */
269: CURSOR get_audsid IS
270: SELECT a.sid, a.serial#, b.spid
271: FROM v$session a, v$process b
272: WHERE audsid = userenv('SESSIONID')
273: AND a.paddr = b.addr;
274:
275: CURSOR get_dbname IS SELECT name FROM v$database;

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

275: CURSOR get_dbname IS SELECT name FROM v$database;
276:
277: v_sid v$session.sid%type;
278: v_serial v$session.serial#%type;
279: v_spid v$process.spid%type;
280: v_name1 v$database.name%type;
281:
282: /*
283: || End of bug 4517919