APPS.JAI_PO_TAX_PKG dependencies on V$SESSION

Line 2195: SELECT a.sid, a.serial#, b.spid FROM v$session a,v$process b

2191: AND b.application_id = a.application_id
2192: AND a.concurrent_program_name = lv_conc_name; --'JAINPOTD';/* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2193:
2194: CURSOR get_audsid IS
2195: SELECT a.sid, a.serial#, b.spid FROM v$session a,v$process b
2196: WHERE audsid = userenv('SESSIONID')
2197: AND a.paddr = b.addr;
2198:
2199: CURSOR get_dbname IS

Line 2204: sid V$SESSION.SID%TYPE;

2200: SELECT name FROM v$database;
2201:
2202: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2203: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2204: sid V$SESSION.SID%TYPE;
2205: serial V$SESSION.SERIAL#%TYPE;
2206: spid V$PROCESS.SPID%TYPE;
2207: v_name1 V$DATABASE.NAME%TYPE;
2208:

Line 2205: serial V$SESSION.SERIAL#%TYPE;

2201:
2202: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2203: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2204: sid V$SESSION.SID%TYPE;
2205: serial V$SESSION.SERIAL#%TYPE;
2206: spid V$PROCESS.SPID%TYPE;
2207: v_name1 V$DATABASE.NAME%TYPE;
2208:
2209: