APPS.HZ_COMMON_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 407: from hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c,fnd_territories_vl d

403: DECODE(c.ADDRESS1, NULL, NULL, ', ') || c.CITY || DECODE(c.CITY,
404: NULL, NULL, ', ') || c.STATE || DECODE(c.STATE, NULL, NULL, ' ') ||
405: c.POSTAL_CODE || DECODE(d.TERRITORY_SHORT_NAME, NULL, NULL, ', ')
406: || d.TERRITORY_SHORT_NAME
407: from hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c,fnd_territories_vl d
408: where a.party_site_id =b.party_site_id
409: and b.location_id = c.location_id
410: and d.territory_code = c.country
411: and a.cust_acct_site_id = v_address_id;