DBA Data[Home] [Help]

APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_ORG_CARRIER_SERVICES

Line 228: FROM wsh_carrier_services a, wsh_org_carrier_services b

224: AND mode_of_transport = c_mode_of_trans;
225:
226: CURSOR c_get_ship_method_code (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2, c_org_id NUMBER) IS
227: SELECT a.ship_method_code, a.ship_method_meaning
228: FROM wsh_carrier_services a, wsh_org_carrier_services b
229: WHERE a.carrier_service_id = b.carrier_service_id
230: AND b.organization_id = c_org_id
231: AND b.enabled_flag = 'Y'
232: AND a.enabled_flag = 'Y'