APPS.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_CARRIERS

Line 812: wsh_carriers wc

808: AND enabled_flag = 'Y'
809: AND meaning like ( p_ship_method_name)
810: AND lookup_code in (select ship_method_code
811: from wsh_carrier_services wcs, wsh_org_carrier_services wocs,
812: wsh_carriers wc
813: where wocs.organization_id = p_organization_id
814: AND wcs.ship_method_code = flv.lookup_code
815: AND wcs.enabled_flag = 'Y'
816: AND wocs.enabled_flag = 'Y'