DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WSH_LOCATIONS

Line 106: FROM wsh_locations

102: ,country
103: ,postal_code
104: ,ui_location_code
105: , NULL -- hr_location_code
106: FROM wsh_locations
107: where wsh_location_id = v_location_id;
108:
109: CURSOR c_hr_locs (v_location_id NUMBER) IS
110: SELECT b.location_code

Line 7323: FROM wsh_locations wl,

7319: IS
7320:
7321: CURSOR c_get_customer(c_location_id IN NUMBER) IS
7322: SELECT hcas.cust_account_id
7323: FROM wsh_locations wl,
7324: hz_party_sites hps,
7325: hz_cust_acct_sites_all hcas
7326: WHERE wl.wsh_location_id = c_location_id
7327: AND wl.location_source_code = 'HZ'