APPS.AR_GTA_TRX_UTIL dependencies on HZ_CUST_SITE_USES

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 2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2204: ----Yao Zhang add end for bug#8404856
2205:
2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2209: l_error_string VARCHAR2(500);
2210:

Line 2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2563: l_error_string VARCHAR2(500);
2564:

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