DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on V$PROCESS

Line 2583: ,v$process pr

2579: ,l_session_id
2580: ,l_program
2581: ,l_module
2582: FROM v$session se
2583: ,v$process pr
2584: WHERE se.audsid = USERENV('SESSIONID')
2585: AND se.paddr = pr.addr;
2586:
2587: SELECT pa.value

Line 2761: V$PROCESS P,

2757: SPID, S.AUDSID
2758: INTO
2759: osp_id, s_id
2760: FROM
2761: V$PROCESS P,
2762: V$SESSION S
2763: WHERE
2764: S.AUDSID = USERENV('SESSIONID')
2765: AND P.Addr = S.Paddr

Line 2794: ,v$process pr

2790: ,se.module -- header and footer
2791: INTO l_program
2792: ,l_module
2793: FROM v$session se
2794: ,v$process pr
2795: WHERE se.audsid = USERENV('SESSIONID')
2796: AND se.paddr = pr.addr;
2797:
2798: l_trace_flag := TRUE;