APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_PARTY_SITES

Line 1446: hz_party_sites party_site,

1442: CURSOR c_territory IS
1443: select ft.territory_short_name
1444: from fnd_territories_vl ft,
1445: hz_cust_acct_sites acct_site,
1446: hz_party_sites party_site,
1447: hz_locations loc
1448: where loc.country = ft.territory_code
1449: and acct_site.party_site_id = party_site.party_site_id
1450: and loc.location_id = party_site.location_id

Line 1500: hz_party_sites party_site,

1496: CURSOR c_territory IS
1497: select ft.rowid
1498: from fnd_territories_vl ft,
1499: hz_cust_acct_sites acct_site,
1500: hz_party_sites party_site,
1501: hz_locations loc
1502: where loc.country = ft.territory_code
1503: and acct_site.party_site_id = party_site.party_site_id
1504: and loc.location_id = party_site.location_id

Line 2058: hz_party_sites party_site,

2054: INTO l_add1, l_add2, l_add3, l_add4,
2055: l_city, l_state,l_province, l_postal_code, l_country,
2056: l_status
2057: FROM hz_cust_acct_sites acct_site,
2058: hz_party_sites party_site,
2059: hz_locations loc
2060: WHERE acct_site.party_site_id = party_site.party_site_id
2061: AND loc.location_id = party_site.location_id
2062: AND acct_site.cust_acct_site_id = p_address_id;