DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on V$SESSION

Line 3654: from v$session s

3650: -- Bug 5046369 start
3651: and (
3652: (pk.status_code IN ('P', 'C')
3653: and exists (select 'Packet is valid for the current session'
3654: from v$session s
3655: WHERE s.audsid = pk.session_id
3656: AND s.serial# = pk.serial_id)
3657: )
3658: OR

Line 7294: FROM v$session

7290: where
7291: Q.status_code IN ('P', 'C')
7292: and ((((sysdate - Q.last_update_date)*24) > 48) OR
7293: (NOT EXISTS (SELECT 'x'
7294: FROM v$session
7295: WHERE audsid = Q.session_id
7296: and Serial# = Q.serial_id)));
7297:
7298: -- =========================== FND LOG ===========================

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

9153:
9154: l_full_path := g_path||'get_session_details';
9155:
9156: select s.audsid, s.serial# into x_session_id, x_serial_id
9157: from v$session s, v$process p
9158: where s.paddr = p.addr
9159: and s.audsid = USERENV('SESSIONID');
9160:
9161: -- =========================== FND LOG ===========================