APPS.JA_JAIN23D_XMLP_PKG dependencies on V$PROCESS

Line 401: V$PROCESS B

397: A.SERIAL#,
398: B.SPID
399: FROM
400: V$SESSION A,
401: V$PROCESS B
402: WHERE AUDSID = USERENV('SESSIONID')
403: AND A.PADDR = B.ADDR;
404: CURSOR GET_DBNAME IS
405: SELECT

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

410: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
411: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
412: V_SID V$SESSION.SID%TYPE;
413: V_SERIAL V$SESSION.SERIAL#%TYPE;
414: V_SPID V$PROCESS.SPID%TYPE;
415: V_NAME V$DATABASE.NAME%TYPE;
416: BEGIN
417: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
418: CP_TRN_FROM_DATE := TO_CHAR(P_TRN_FROM_DATE,'DD-MON-YYYY');