APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 1535: hz_cust_acct_sites acct_site,

1531: /* modified for tca uptake */
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

Line 1589: hz_cust_acct_sites acct_site,

1585: /* modified for tca uptake */
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

Line 1703: hz_cust_acct_sites acct_site,

1699: (
1700: SELECT 'commitments_exist'
1701: FROM hz_cust_accounts cust_acct,
1702: so_agreements soa,
1703: hz_cust_acct_sites acct_site,
1704: ra_cust_trx_types inv_type,
1705: ra_cust_trx_types type,
1706: ra_customer_trx trx
1707: WHERE trx.cust_trx_type_id = type.cust_trx_type_id

Line 2176: FROM hz_cust_acct_sites acct_site,

2172: acct_site.STATUS
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