APPS.HZ_UI_UTIL_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

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 499: FROM HZ_CUST_ACCT_SITES_ALL site,

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
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