APPS.JA_JAINPLA_XMLP_PKG dependencies on V$PROCESS

Line 571: V$PROCESS B

567: A.SERIAL#,
568: B.SPID
569: FROM
570: V$SESSION A,
571: V$PROCESS B
572: WHERE AUDSID = USERENV('SESSIONID')
573: AND A.PADDR = B.ADDR;
574: CURSOR GET_DBNAME IS
575: SELECT

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

579: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
580: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
581: V_SID V$SESSION.SID%TYPE;
582: V_SERIAL V$SESSION.SERIAL#%TYPE;
583: V_SPID V$PROCESS.SPID%TYPE;
584: V_NAME V$DATABASE.NAME%TYPE;
585:
586: BEGIN
587: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;