APPS.OZF_LOCATION_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 297: hz_cust_site_uses_all hzcsu,

293: IS
294: SELECT
295: hzps.location_id location_id
296: FROM
297: hz_cust_site_uses_all hzcsu,
298: hz_cust_acct_sites_all hzcas,
299: hz_party_sites hzps
300: WHERE
301: hzcsu.site_use_id = p_site_use_id

Line 342: hz_cust_site_uses_all hzcsu

338:
339: /*
340: SELECT hz.party_name||' '||hzcsu.location into x_party_name
341: FROM hz_parties hz,
342: hz_cust_site_uses_all hzcsu
343: WHERE hzcsu.site_use_id = p_site_use_id
344: AND hz.party_id = p_party_id;
345: */
346: BEGIN

Line 359: FROM hz_cust_site_uses_all hzcsu

355: x_party_name := fnd_message.get_string('OZF', 'OZF_TP_UNALLOC_ACCOUNT_TXT');
356: END IF;
357: BEGIN
358: SELECT hzcsu.location into x_location
359: FROM hz_cust_site_uses_all hzcsu
360: WHERE hzcsu.site_use_id = p_site_use_id;
361: EXCEPTION
362: WHEN OTHERS THEN
363: x_location := TO_CHAR(p_site_use_id);