DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on WSH_CARRIER_SERVICES_V

Line 51: wsh_carrier_services_v wcs,

47: CURSOR c_service_exists
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