APPS.JA_JAINRG1_XMLP_PKG dependencies on V$PROCESS

Line 294: V$PROCESS B

290: A.SERIAL#,
291: B.SPID
292: FROM
293: V$SESSION A,
294: V$PROCESS B
295: WHERE AUDSID = USERENV('SESSIONID')
296: AND A.PADDR = B.ADDR;
297: CURSOR GET_DBNAME IS
298: SELECT

Line 306: V_SPID V$PROCESS.SPID%TYPE;

302: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
303: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
304: V_SID V$SESSION.SID%TYPE;
305: V_SERIAL V$SESSION.SERIAL#%TYPE;
306: V_SPID V$PROCESS.SPID%TYPE;
307: V_NAME1 V$DATABASE.NAME%TYPE;
308: BEGIN
309: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
310: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;