DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on WSH_CARRIER_SERVICES

Line 720: -- Added nvl to wcs.service_level and wcs.mode_of_transport because they could be NULL in wsh_carrier_services

716: x_return_status OUT NOCOPY VARCHAR2)
717: IS
718:
719: -- Bug fix 2930693
720: -- Added nvl to wcs.service_level and wcs.mode_of_transport because they could be NULL in wsh_carrier_services
721: -- bug 3479643
722: -- Created a separate cursor so that for 945 inbound, we can
723: -- use the delivery's ship method to validate the incoming ship method
724: cursor c_ship_method_cur is

Line 726: from wsh_carrier_services wcs,

722: -- Created a separate cursor so that for 945 inbound, we can
723: -- use the delivery's ship method to validate the incoming ship method
724: cursor c_ship_method_cur is
725: select wcs.ship_method_code
726: from wsh_carrier_services wcs,
727: wsh_carriers_v wcar
728: where wcar.carrier_name = p_carrier_name
729: and nvl(wcs.service_level, '!') = nvl(p_service_level, '!')
730: and nvl(wcs.mode_of_transport, '!') = nvl(p_mode_of_transport, '!')