DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on HZ_CUST_SITE_USES_ALL

Line 282: select SITE_USE_ID from HZ_CUST_SITE_USES_ALL

278: p_site_id OUT NOCOPY NUMBER,
279: x_return_status OUT NOCOPY VARCHAR2) IS
280:
281: CURSOR get_id (c_site_code VARCHAR2) IS
282: select SITE_USE_ID from HZ_CUST_SITE_USES_ALL
283: where SITE_USE_CODE = c_site_code;
284:
285:
286: --

Line 394: hz_cust_site_uses_all su

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