APPS.FTE_LTL_LOADER dependencies on WSH_CARRIERS

Line 3997: wsh_carriers

3993: scac_code
3994: INTO
3995: l_scac
3996: FROM
3997: wsh_carriers
3998: WHERE
3999: carrier_id = p_carrier_ids(q);
4000:
4001: OBSOLETE_PREVIOUS_LOAD (p_lane_type => G_DIRECTION_FLAG || '_LTL_' || l_scac || '_' || l_origin || '_%',

Line 4906: FROM wsh_carriers

4902: -- Obsolete pre-10+ lanes for these carriers
4903: IF (G_SERVICE_CODE = 'LTL') THEN
4904: FOR q IN 1..l_add_carriers.COUNT LOOP
4905: SELECT scac_code INTO l_scac
4906: FROM wsh_carriers
4907: WHERE carrier_id = l_add_carriers(q);
4908:
4909: OPEN Get_Previous_Regions_Info (p_tariff_name => p_tariff_name,
4910: p_lane_type => 'LTL_' || p_tariff_name || '_' || l_load_number);