APPS.CLN_SHOWSHIP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 152

      select hps.party_site_id, hps.party_id, wnd.asn_date_sent, wnd.asn_seq_number, wnd.organization_id
      from   wsh_new_deliveries  wnd, wsh_locations wl, hz_party_sites hps
      where  wnd.delivery_id = p_delivery_id
      and    wnd.ultimate_dropoff_location_id = wl.wsh_location_id
      and    wl.LOCATION_SOURCE_CODE = 'HZ'
      and    wl.SOURCE_LOCATION_ID = hps.location_id;

Line: 220

	select count(*) into cnt
      from   wsh_new_deliveries wnd,
             wsh_delivery_assignments wda
      where  wnd.delivery_id   = wda.delivery_id
      and    wda.delivery_id   = p_delivery_id
      and    wnd.status_code not in ('SR','SC','OP');

Line: 248

         SELECT CLN_SHOWSHIP_S.nextval into l_showship_seq from dual;

Line: 251

         SELECT sysdate into l_date from dual;

Line: 260

         WSH_ECE_VIEWS_DEF.update_del_asn_info(
              x_delivery_id => p_delivery_id,
              x_time_stamp_sequence_number => l_time_stamp_seq_old,
              x_time_stamp_date => l_time_stamp_date_old,
              x_g_time_stamp_sequence_number => l_time_stamp_seq_new,
              x_g_time_stamp_date => l_time_stamp_date_new);