APPS.WSH_UTIL_CORE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 393: hz_cust_acct_sites_all ca,

389:
390: CURSOR site_to_loc (v_site_id NUMBER) IS
391: SELECT ps.location_id
392: FROM hz_party_sites ps,
393: hz_cust_acct_sites_all ca,
394: hz_cust_site_uses_all su
395: WHERE su.site_use_id = v_site_id
396: AND su.cust_acct_site_id = ca.cust_acct_site_id
397: AND ca.party_site_id = ps.party_site_id;

Line 7361: hz_cust_acct_sites_all hcas

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