DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on V$PROCESS

Line 108: v_spid v$process.spid%type;

104:
105: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
106: v_sid v$session.sid%type;
107: v_serial v$session.serial#%type;
108: v_spid v$process.spid%type;
109: v_name1 v$database.name%type;
110:
111: CURSOR c_enable_trace(cp_conc_pname fnd_concurrent_programs.concurrent_program_name%type) IS
112: SELECT enable_trace

Line 118: FROM v$session a, v$process b

114: WHERE concurrent_program_name = cp_conc_pname ; --'JAINRGRND';
115:
116: CURSOR get_audsid IS
117: SELECT a.sid, a.serial#, b.spid
118: FROM v$session a, v$process b
119: WHERE audsid = userenv('SESSIONID')
120: AND a.paddr = b.addr;
121:
122: CURSOR get_dbname IS SELECT name FROM v$database;