DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_LOCATIONS

Line 10157: WSH_LOCATIONS_PKG.Convert_internal_cust_location(

10153: IF l_debug_on THEN
10154: wsh_debug_sv.logmsg(l_module_name,'stop location id has been changed');
10155: END IF;
10156: -- Derive physical Location id for this new location
10157: WSH_LOCATIONS_PKG.Convert_internal_cust_location(
10158: p_internal_cust_location_id => p_location_id,
10159: x_internal_org_location_id => l_physical_location_id, -- New physical Location id
10160: x_return_status => l_return_status);
10161:

Line 10843: FROM wsh_locations wl,

10839: IS
10840:
10841: CURSOR c_get_shipto_cust_from_loc (p_location_id IN NUMBER) IS
10842: SELECT hcas.cust_account_id
10843: FROM wsh_locations wl,
10844: hz_party_sites hps,
10845: hz_cust_acct_sites_all hcas
10846: WHERE wl.wsh_location_id = p_location_id
10847: AND wl.location_source_code = 'HZ'