APPS.OE_ADV_PRICE_PVT dependencies on WSH_CARRIER_SERVICES

Line 681: FROM wsh_carrier_services wsh,

677: px_header_rec.shipping_method_code := i.Substitution_value_to;
678: --bug 4190357
679: SELECT count(*)
680: INTO l_count
681: FROM wsh_carrier_services wsh,
682: wsh_org_carrier_services wsh_org
683: WHERE wsh_org.organization_id = px_header_rec.ship_from_org_id
684: AND wsh.carrier_service_id = wsh_org.carrier_service_id
685: AND wsh.ship_method_code = px_header_rec.shipping_method_code