DBA Data[Home] [Help]

APPS.FUN_RULE_UTILITY_PKG dependencies on V$PROCESS

Line 469: l_spid V$PROCESS.spid%TYPE;

465: */
466:
467: FUNCTION get_session_process_id RETURN VARCHAR2 IS
468:
469: l_spid V$PROCESS.spid%TYPE;
470:
471: BEGIN
472:
473: SELECT SPID INTO l_spid

Line 474: FROM V$PROCESS

470:
471: BEGIN
472:
473: SELECT SPID INTO l_spid
474: FROM V$PROCESS
475: WHERE ADDR = (
476: SELECT PADDR
477: FROM V$SESSION
478: WHERE AUDSID = USERENV('SESSIONID') );