29: AND a.carrier_id = c_carrier_id;
30:
31: CURSOR c_get_carrier_freight_code (c_carrier_id VARCHAR2) IS
32: SELECT freight_code
33: FROM wsh_carriers
34: WHERE carrier_id = c_carrier_id;
35:
36: CURSOR c_get_generic_carrier_flag (c_carrier_id VARCHAR2) IS
37: SELECT generic_flag
34: WHERE carrier_id = c_carrier_id;
35:
36: CURSOR c_get_generic_carrier_flag (c_carrier_id VARCHAR2) IS
37: SELECT generic_flag
38: FROM wsh_carriers
39: WHERE carrier_id = c_carrier_id;
40:
41: CURSOR c_get_generic_carrier_flag2 (c_ship_method_code VARCHAR2) IS
42: SELECT a.generic_flag
39: WHERE carrier_id = c_carrier_id;
40:
41: CURSOR c_get_generic_carrier_flag2 (c_ship_method_code VARCHAR2) IS
42: SELECT a.generic_flag
43: FROM wsh_carriers a, wsh_carrier_services b
44: WHERE a.carrier_id = b.carrier_id
45: AND b.ship_method_code = c_ship_method_code;
46:
47: CURSOR c_carrier_services(c_shp_mthd_cd VARCHAR2)