APPS.HZ_UI_UTIL_PKG dependencies on HZ_PARTIES

Line 63: IF p_entity_name = 'HZ_PARTIES' THEN

59: IS
60: l_alias VARCHAR2(30);
61: BEGIN
62:
63: IF p_entity_name = 'HZ_PARTIES' THEN
64: IF p_entity_alias IS NOT NULL THEN
65: l_alias := p_entity_alias;
66: ELSE
67: l_alias := p_entity_name;

Line 494: from HZ_PARTIES party, HZ_RELATIONSHIPS reln

490: SELECT HZ_FORMAT_PUB.format_address(party_site.location_id, null, null, ', ')
491: ||decode(acct.PARTY_ID,
492: party_site.PARTY_ID,'',
493: ' ('||(select party.PARTY_NAME
494: from HZ_PARTIES party, HZ_RELATIONSHIPS reln
495: where party_site.PARTY_ID = reln.PARTY_ID
496: AND reln.SUBJECT_TYPE = 'PERSON'
497: AND reln.SUBJECT_ID = party.PARTY_ID)||')')
498: INTO x_formatted_address