APPS.OZF_LOCATION_PVT dependencies on HZ_PARTIES

Line 341: FROM hz_parties hz,

337: BEGIN
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: */

Line 348: FROM hz_parties hz

344: AND hz.party_id = p_party_id;
345: */
346: BEGIN
347: SELECT hz.party_name into x_party_name
348: FROM hz_parties hz
349: WHERE hz.party_id = p_party_id;
350: EXCEPTION
351: WHEN OTHERS THEN
352: x_party_name := TO_CHAR(p_party_id);