APPS.WSH_OTM_RIQ_XML dependencies on WSH_ORG_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'