APPS.WSH_OTM_RIQ_XML dependencies on WSH_CARRIER_SERVICES

Line 1666: FROM wsh_carrier_services a, wsh_org_carrier_services b

1662: IS
1663:
1664: CURSOR c_get_ship_method_code (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2, c_org_id NUMBER) IS
1665: SELECT a.ship_method_code
1666: FROM wsh_carrier_services a, wsh_org_carrier_services b
1667: WHERE a.carrier_service_id = b.carrier_service_id
1668: AND b.organization_id = c_org_id
1669: AND b.enabled_flag = 'Y'
1670: AND a.enabled_flag = 'Y'

Line 2227: FROM wsh_carrier_services

2223:
2224: CURSOR c_SM_Components(c_shp_mthd_cd VARCHAR2)
2225: IS
2226: SELECT carrier_id, mode_of_transport,service_level
2227: FROM wsh_carrier_services
2228: WHERE ship_method_code = c_shp_mthd_cd;
2229:
2230:
2231: l_carrier_freight_code VARCHAR2(30);