APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_PARTY_SITES

Line 1536: hz_party_sites party_site,

1532: CURSOR c_territory IS
1533: select ft.territory_short_name
1534: from fnd_territories_vl ft,
1535: hz_cust_acct_sites acct_site,
1536: hz_party_sites party_site,
1537: hz_locations loc
1538: where loc.country = ft.territory_code
1539: and acct_site.party_site_id = party_site.party_site_id
1540: and loc.location_id = party_site.location_id

Line 1590: hz_party_sites party_site,

1586: CURSOR c_territory IS
1587: select ft.rowid
1588: from fnd_territories_vl ft,
1589: hz_cust_acct_sites acct_site,
1590: hz_party_sites party_site,
1591: hz_locations loc
1592: where loc.country = ft.territory_code
1593: and acct_site.party_site_id = party_site.party_site_id
1594: and loc.location_id = party_site.location_id

Line 2177: hz_party_sites party_site,

2173: INTO l_add1, l_add2, l_add3, l_add4,
2174: l_city, l_state,l_province, l_postal_code, l_country,
2175: l_status
2176: FROM hz_cust_acct_sites acct_site,
2177: hz_party_sites party_site,
2178: hz_locations loc
2179: WHERE acct_site.party_site_id = party_site.party_site_id
2180: AND loc.location_id = party_site.location_id
2181: AND acct_site.cust_acct_site_id = p_address_id;