APPS.AR_GTA_TRX_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 216: hz_cust_site_uses_all hcsua,

212: BEGIN
213: SELECT HCA.CLASS_CODE
214: INTO l_class_code
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

Line 3530: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%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;

Line 3608: hz_cust_site_uses_all

3604: cust_acct_site_id
3605: INTO
3606: l_cust_acct_site_id
3607: FROM
3608: hz_cust_site_uses_all
3609: WHERE SITE_USE_ID = l_bill_to_site_use_id;
3610:
3611: --get party_site_id by cust_acct_site_id
3612: SELECT