DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_LOCATIONS

Line 9961: WSH_LOCATIONS_PKG.Convert_internal_cust_location(

9957: IF l_debug_on THEN
9958: wsh_debug_sv.logmsg(l_module_name,'stop location id has been changed');
9959: END IF;
9960: -- Derive physical Location id for this new location
9961: WSH_LOCATIONS_PKG.Convert_internal_cust_location(
9962: p_internal_cust_location_id => p_location_id,
9963: x_internal_org_location_id => l_physical_location_id, -- New physical Location id
9964: x_return_status => l_return_status);
9965:

Line 10647: FROM wsh_locations wl,

10643: IS
10644:
10645: CURSOR c_get_shipto_cust_from_loc (p_location_id IN NUMBER) IS
10646: SELECT hcas.cust_account_id
10647: FROM wsh_locations wl,
10648: hz_party_sites hps,
10649: hz_cust_acct_sites_all hcas
10650: WHERE wl.wsh_location_id = p_location_id
10651: AND wl.location_source_code = 'HZ'