DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on V$SESSION

Line 3729: from v$session s

3725: -- Bug 5046369 start
3726: and (
3727: (pk.status_code IN ('P', 'C')
3728: and exists (select 'Packet is valid for the current session'
3729: from v$session s
3730: WHERE s.audsid = pk.session_id
3731: AND s.serial# = pk.serial_id)
3732: )
3733: OR

Line 7369: FROM v$session

7365: where
7366: Q.status_code IN ('P', 'C')
7367: and ((((sysdate - Q.last_update_date)*24) > 48) OR
7368: (NOT EXISTS (SELECT 'x'
7369: FROM v$session
7370: WHERE audsid = Q.session_id
7371: and Serial# = Q.serial_id)));
7372:
7373: -- =========================== FND LOG ===========================

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

9339:
9340: l_full_path := g_path||'get_session_details';
9341:
9342: select s.audsid, s.serial# into x_session_id, x_serial_id
9343: from v$session s, v$process p
9344: where s.paddr = p.addr
9345: and s.audsid = USERENV('SESSIONID');
9346:
9347: -- =========================== FND LOG ===========================