DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on WSH_CARRIERS_V

Line 52: wsh_carriers_v wc

48: (p_carrier_service_id number,p_freight_code varchar2,p_organization_id number) is
49: SELECT 'Y'
50: FROM wsh_org_carrier_services wocs,
51: wsh_carrier_services_v wcs,
52: wsh_carriers_v wc
53: WHERE wc.carrier_id = wcs.carrier_id
54: and wocs.carrier_service_id = wcs.carrier_service_id
55: and wocs.carrier_service_id <> p_carrier_service_id
56: and wc.freight_code = p_freight_code