DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on HZ_PARTY_SITES

Line 392: FROM hz_party_sites ps,

388:
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

Line 7360: hz_party_sites hps,

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