DBA Data[Home] [Help]

APPS.IGI_DOS_FUNDS dependencies on V$PROCESS

Line 95: from v$session s, v$process p

91:
92:
93: begin
94: select s.audsid, s.serial# into l_session_id, l_serial_id
95: from v$session s, v$process p
96: where s.paddr = p.addr
97: and s.audsid = USERENV('SESSIONID');
98: exception
99: when others then

Line 328: from v$session s, v$process p

324: BEGIN
325:
326: begin
327: select s.audsid, s.serial# into l_session_id, l_serial_id
328: from v$session s, v$process p
329: where s.paddr = p.addr
330: and s.audsid = USERENV('SESSIONID');
331: exception
332: when others then