APPS.GMS_SWEEPER dependencies on GMS_BC_PACKET_ARRIVAL_ORDER

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

1573: WHERE audsid = gms.session_id
1574: and Serial# = gms.serial_id);
1575:
1576: ---------------------------------------------------------------------------------- +
1577: x_stage := '200'; -- Delete from gms_bc_packet_arrival_order
1578: IF L_DEBUG = 'Y' THEN
1579: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');
1580: END IF;
1581:

Line 1582: DELETE gms_bc_packet_arrival_order ao

1578: IF L_DEBUG = 'Y' THEN
1579: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');
1580: END IF;
1581:
1582: DELETE gms_bc_packet_arrival_order ao
1583: WHERE NOT EXISTS (
1584: SELECT 1
1585: FROM gms_bc_packets
1586: WHERE packet_id = ao.packet_id