APPS.FTE_FREIGHT_PRICING dependencies on WSH_CARRIERS

Line 140: wsh_carriers c

136: IS
137: SELECT count(a.delivery_id)
138: FROM wsh_new_deliveries a,
139: mtl_parameters b,
140: wsh_carriers c
141: WHERE a.organization_id = b.organization_id
142: AND a.carrier_id = c.carrier_id
143: AND c.manifesting_enabled_flag = 'Y'
144: AND b.carrier_manifesting_flag = 'Y'

Line 153: wsh_carriers c

149: IS
150: SELECT count(a.delivery_id)
151: FROM wsh_new_deliveries a,
152: mtl_parameters b,
153: wsh_carriers c
154: WHERE a.organization_id = b.organization_id
155: AND a.carrier_id = c.carrier_id
156: AND c.manifesting_enabled_flag = 'Y'
157: AND b.carrier_manifesting_flag = 'Y'

Line 7182: x_currency_code OUT NOCOPY wsh_carriers.currency_code%TYPE,

7178: END process_shipment_pattern;
7179:
7180: PROCEDURE get_currency_code (
7181: p_carrier_id IN NUMBER,
7182: x_currency_code OUT NOCOPY wsh_carriers.currency_code%TYPE,
7183: x_return_status OUT NOCOPY VARCHAR2)
7184: IS
7185:
7186: CURSOR c_get_currency IS

Line 7188: FROM wsh_carriers

7184: IS
7185:
7186: CURSOR c_get_currency IS
7187: SELECT currency_code
7188: FROM wsh_carriers
7189: WHERE carrier_id = p_carrier_id;
7190:
7191: --l_currency_code wsh_carriers.currency_code%TYPE;
7192:

Line 7191: --l_currency_code wsh_carriers.currency_code%TYPE;

7187: SELECT currency_code
7188: FROM wsh_carriers
7189: WHERE carrier_id = p_carrier_id;
7190:
7191: --l_currency_code wsh_carriers.currency_code%TYPE;
7192:
7193: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
7194:
7195: BEGIN