DBA Data[Home] [Help]

APPS.PA_SWEEPER dependencies on V$SESSION

Line 353: FROM v$session

349: where pbc.status_code in ('P')
350: and ((pbc.session_id is not null and
351: pbc.serial_id is not null and
352: NOT EXISTS (SELECT 'x'
353: FROM v$session
354: WHERE audsid = pbc.session_id
355: AND Serial# = pbc.serial_id)
356: ) OR
357: (pbc.session_id is null and