APPS.WSH_UTIL_CORE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 387: hz_cust_acct_sites_all ca,

383:
384: CURSOR site_to_loc (v_site_id NUMBER) IS
385: SELECT ps.location_id
386: FROM hz_party_sites ps,
387: hz_cust_acct_sites_all ca,
388: hz_cust_site_uses_all su
389: WHERE su.site_use_id = v_site_id
390: AND su.cust_acct_site_id = ca.cust_acct_site_id
391: AND ca.party_site_id = ps.party_site_id;

Line 7325: hz_cust_acct_sites_all hcas

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'
7328: AND wl.source_location_id = hps.location_id
7329: AND hps.party_site_id = hcas.party_site_id;