APPS.WSH_CONC_UTIL_PKG dependencies on WSH_CARRIERS

Line 29: from wsh_carriers wc, wsh_carrier_services wcs

25:
26:
27: cursor c_get_new_fgt_code (p_ship_method_code varchar2) is
28: select wc.freight_code, wc.carrier_id
29: from wsh_carriers wc, wsh_carrier_services wcs
30: where
31: wcs.ship_method_code = p_ship_method_code
32: and wcs.carrier_id = wc.carrier_id;
33:

Line 40: not exists (select 'x' from wsh_carriers wc,

36: cursor c_get_comb_notupg is
37: select wcsm.ship_method_code , wcsm.organization_id , wcsm.freight_code
38: from wsh_carrier_ship_methods wcsm
39: where
40: not exists (select 'x' from wsh_carriers wc,
41: wsh_carrier_services wcs
42: where
43: wc.freight_code = wcsm.freight_code
44: and wc.carrier_id = wcs.carrier_id