APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_CARRIER_SERVICES

Line 2666: FROM wsh_carrier_services

2662: AND ship_method = p_ship_method_code;
2663:
2664: CURSOR get_ship_method_cur IS
2665: SELECT ship_method_code
2666: FROM wsh_carrier_services
2667: WHERE carrier_id = p_carrier_id
2668: AND enabled_flag = 'Y'
2669: AND ( (p_mode_code IS NULL AND mode_of_transport IS NULL)
2670: OR (p_mode_code IS NOT NULL AND mode_of_transport = p_mode_code)