APPS.JAI_PO_TAX_PKG dependencies on V$PROCESS

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 2206: spid V$PROCESS.SPID%TYPE;

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:
2210: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.batch_quot_taxes_copy';