APPS.GMS_SWEEPER dependencies on GMS_BC_PACKET_ARRIVAL_ORDER

Line 1566: x_stage := '200'; -- Delete from gms_bc_packet_arrival_order

1562: WHERE audsid = gms.session_id
1563: and Serial# = gms.serial_id);
1564:
1565: ---------------------------------------------------------------------------------- +
1566: x_stage := '200'; -- Delete from gms_bc_packet_arrival_order
1567: IF L_DEBUG = 'Y' THEN
1568: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');
1569: END IF;
1570:

Line 1571: DELETE gms_bc_packet_arrival_order ao

1567: IF L_DEBUG = 'Y' THEN
1568: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');
1569: END IF;
1570:
1571: DELETE gms_bc_packet_arrival_order ao
1572: WHERE NOT EXISTS (
1573: SELECT 1
1574: FROM gms_bc_packets
1575: WHERE packet_id = ao.packet_id