DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on HZ_CUST_SITE_USES_ALL

Line 278: select SITE_USE_ID from HZ_CUST_SITE_USES_ALL

274: p_site_id OUT NOCOPY NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2) IS
276:
277: CURSOR get_id (c_site_code VARCHAR2) IS
278: select SITE_USE_ID from HZ_CUST_SITE_USES_ALL
279: where SITE_USE_CODE = c_site_code;
280:
281:
282: --

Line 388: hz_cust_site_uses_all su

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;
392: