APPS.WSH_CARRIERS_GRP dependencies on WSH_CARRIERS_V

Line 110: FROM wsh_carriers_v wc

106: AND carrier_id <> p_carrier_id;
107:
108: CURSOR Get_Carrier_Name_Create(p_carrier_name VARCHAR2) IS
109: SELECT carrier_id
110: FROM wsh_carriers_v wc
111: WHERE wc.active= 'A' AND
112: upper(wc.carrier_name) = upper(p_carrier_name);
113:
114: CURSOR Get_Carrier_Name_Update(p_carrier_id NUMBER,p_carrier_name VARCHAR2) IS

Line 116: FROM wsh_carriers_v wc

112: upper(wc.carrier_name) = upper(p_carrier_name);
113:
114: CURSOR Get_Carrier_Name_Update(p_carrier_id NUMBER,p_carrier_name VARCHAR2) IS
115: SELECT carrier_id
116: FROM wsh_carriers_v wc
117: WHERE wc.active = 'A'
118: AND upper(wc.carrier_name) = upper(p_carrier_name)
119: AND wc.carrier_id <> p_carrier_id;
120:

Line 123: FROM wsh_carriers_v

119: AND wc.carrier_id <> p_carrier_id;
120:
121: CURSOR Check_Generic_Carr(p_freight_code VARCHAR2) IS
122: SELECT carrier_name
123: FROM wsh_carriers_v
124: WHERE nvl(generic_flag, 'N') = 'Y' AND
125: freight_code <> nvl(p_freight_code, ' ') AND
126: active = 'A';
127: