APPS.HZ_UI_UTIL_PKG dependencies on HZ_PARTY_SITES

Line 254: 'HZ_LOCATIONS', 'HZ_PARTY_SITES', 'HZ_FINANCIAL_NUMBERS') then

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 (
257: p_actual_content_source => p_data_source,
258: p_new_actual_content_source => 'USER_ENTERED',

Line 440: FROM HZ_PARTY_SITES hps , HZ_CUST_ACCT_SITES_ALL hcas

436: IF p_cust_acct_id IS NOT NULL THEN
437: BEGIN
438: SELECT hz_format_pub.format_address ( hps.LOCATION_ID , null , null ,' , ' , null , null , null , null )
439: INTO x_billto_address
440: FROM HZ_PARTY_SITES hps , HZ_CUST_ACCT_SITES_ALL hcas
441: WHERE hcas.BILL_TO_FLAG='P'
442: AND hcas.CUST_ACCOUNT_ID = p_cust_acct_id
443: AND hcas.PARTY_SITE_ID = hps.PARTY_SITE_ID;
444: EXCEPTION

Line 501: HZ_PARTY_SITES party_site

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;
505: EXCEPTION