DBA Data[Home] [Help]

APPS.GMS_SWEEPER dependencies on V$SESSION

Line 1572: FROM v$session

1568: --R12 Fundscheck Management uptake: Logic added to delete records in P status associated with inactive session.
1569: delete from gms_bc_packets gms
1570: where status_code IN ('P')
1571: and NOT EXISTS (SELECT 'x'
1572: FROM v$session
1573: WHERE audsid = gms.session_id
1574: and Serial# = gms.serial_id);
1575:
1576: ---------------------------------------------------------------------------------- +