APPS.WSH_MAPPING_DATA dependencies on WSH_CARRIERS

Line 729: wsh_carriers_v wcar

725: -- use the delivery's ship method to validate the incoming ship method
726: cursor c_ship_method_cur is
727: select wcs.ship_method_code
728: from wsh_carrier_services wcs,
729: wsh_carriers_v wcar
730: where wcar.carrier_name = p_carrier_name
731: and nvl(wcs.service_level, '!') = nvl(p_service_level, '!')
732: and nvl(wcs.mode_of_transport, '!') = nvl(p_mode_of_transport, '!')
733: and wcs.carrier_id = wcar.carrier_id;

Line 2863: wsh_carriers wc

2859:
2860: select wc.freight_code, wcs.service_level, wcs.mode_of_transport
2861: into x_carrier_code, x_service_level, x_mode_of_transport
2862: from wsh_carrier_services wcs,
2863: wsh_carriers wc
2864: where wc.carrier_id = wcs.carrier_id
2865: and wcs.ship_method_code = p_ship_method_code;
2866:
2867: --