APPS.AR_GTA_TRX_UTIL dependencies on HZ_CODE_ASSIGNMENTS

Line 180: l_class_code hz_code_assignments.CLASS_CODE%TYPE;

176: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
177: l_error_string VARCHAR2(1000);
178:
179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
180: l_class_code hz_code_assignments.CLASS_CODE%TYPE;
181: l_document_subtype zx_lines_det_factors.DOCUMENT_SUB_TYPE%TYPE;
182:
183: BEGIN
184:

Line 218: hz_code_assignments HCA,

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
221: AND hcsua.cust_acct_site_id=HCASA.CUST_ACCT_SITE_ID
222: AND HCASA.PARTY_SITE_ID=ZPTP.PARTY_ID

Line 243: hz_code_assignments HCA

239: FROM ra_customer_trx_all h,
240: Hz_Parties RAC_BILL_PARTY,
241: Hz_Cust_Accounts RAC_BILL,
242: zx_party_tax_profile ZPTP,
243: hz_code_assignments HCA
244: WHERE h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
245: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id
246: AND ZPTP.PARTY_ID = RAC_BILL_PARTY.Party_Id
247: AND ZPTP.PARTY_TYPE_CODE = 'THIRD_PARTY'