DBA Data[Home] [Help]

APPS.GMS_SWEEPER dependencies on V$SESSION

Line 1561: FROM v$session

1557: --R12 Fundscheck Management uptake: Logic added to delete records in P status associated with inactive session.
1558: delete from gms_bc_packets gms
1559: where status_code IN ('P')
1560: and NOT EXISTS (SELECT 'x'
1561: FROM v$session
1562: WHERE audsid = gms.session_id
1563: and Serial# = gms.serial_id);
1564:
1565: ---------------------------------------------------------------------------------- +