DBA Data[Home] [Help]

APPS.HZ_UI_UTIL_PKG dependencies on HZ_CUST_ACCOUNTS

Line 500: HZ_CUST_ACCOUNTS acct,

496: AND reln.SUBJECT_TYPE = 'PERSON'
497: AND reln.SUBJECT_ID = party.PARTY_ID)||')')
498: INTO x_formatted_address
499: FROM HZ_CUST_ACCT_SITES_ALL site,
500: HZ_CUST_ACCOUNTS acct,
501: HZ_PARTY_SITES party_site
502: WHERE site.CUST_ACCT_SITE_ID = p_cust_acct_site_id
503: AND party_site.PARTY_SITE_ID = site.PARTY_SITE_ID
504: AND acct.CUST_ACCOUNT_ID = site.CUST_ACCOUNT_ID;