DBA Data[Home] [Help]

APPS.HZ_UI_UTIL_PKG dependencies on HZ_RELATIONSHIPS

Line 252: If p_entity_name in ('HZ_RELATIONSHIPS', 'HZ_CODE_ASSIGNMENTS',

248: * CPUI should display update enabled icon in the UI so that
249: * primary_flag, start_date, status etc columns can be updated.
250: * Error will be raised from API if the rules are violated
251: *
252: If p_entity_name in ('HZ_RELATIONSHIPS', 'HZ_CODE_ASSIGNMENTS',
253: 'HZ_CONTACT_POINTS', 'HZ_CREDIT_RATINGS', 'HZ_FINANCIAL_REPORTS',
254: 'HZ_LOCATIONS', 'HZ_PARTY_SITES', 'HZ_FINANCIAL_NUMBERS') then
255:
256: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege (

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