APPS.AR_GTA_TRX_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 219: HZ_CUST_ACCT_SITES_ALL HCASA

215: FROM ra_customer_trx_all h,
216: hz_cust_site_uses_all hcsua,
217: zx_party_tax_profile ZPTP,
218: hz_code_assignments HCA,
219: HZ_CUST_ACCT_SITES_ALL HCASA
220: WHERE h.bill_to_site_use_id=hcsua.SITE_USE_ID
221: AND hcsua.cust_acct_site_id=HCASA.CUST_ACCT_SITE_ID
222: AND HCASA.PARTY_SITE_ID=ZPTP.PARTY_ID
223: AND ZPTP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

Line 3531: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;

3527: l_reg_tax zx_registrations.tax%TYPE;
3528: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
3529:
3530: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
3531: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;
3532: l_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
3533:
3534: l_tax_registration_count NUMBER;
3535: l_tax_profile_status NUMBER;

Line 3617: hz_cust_acct_sites_all

3613: party_site_id
3614: INTO
3615: l_party_site_id
3616: FROM
3617: hz_cust_acct_sites_all
3618: WHERE cust_acct_site_id = l_cust_acct_site_id;
3619: EXCEPTION
3620: WHEN no_data_found THEN
3621: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site

3805: THEN
3806: BEGIN
3807: SELECT party_id
3808: INTO l_party_id
3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site
3810: WHERE acct.CUST_ACCount_ID = acct_site.CUST_ACCount_ID
3811: AND acct_site.party_site_id = l_party_site_id;
3812:
3813: SELECT reg.registration_number,