DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WSH_LOCATIONS

Line 110: FROM wsh_locations

106: ,country
107: ,postal_code
108: ,ui_location_code
109: , NULL -- hr_location_code
110: FROM wsh_locations
111: where wsh_location_id = v_location_id;
112:
113: CURSOR c_hr_locs (v_location_id NUMBER) IS
114: SELECT b.location_code

Line 7359: FROM wsh_locations wl,

7355: IS
7356:
7357: CURSOR c_get_customer(c_location_id IN NUMBER) IS
7358: SELECT hcas.cust_account_id
7359: FROM wsh_locations wl,
7360: hz_party_sites hps,
7361: hz_cust_acct_sites_all hcas
7362: WHERE wl.wsh_location_id = c_location_id
7363: AND wl.location_source_code = 'HZ'