APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_CARRIER_SERVICES

Line 2682: FROM wsh_carrier_services

2678: AND ship_method = p_ship_method_code;
2679:
2680: CURSOR get_ship_method_cur IS
2681: SELECT ship_method_code
2682: FROM wsh_carrier_services
2683: WHERE carrier_id = p_carrier_id
2684: AND enabled_flag = 'Y'
2685: AND ( (p_mode_code IS NULL AND mode_of_transport IS NULL)
2686: OR (p_mode_code IS NOT NULL AND mode_of_transport = p_mode_code)