APPS.JL_AR_AUTOINV_PKG dependencies on HZ_CUST_ACCT_SITES

Line 82: FROM hz_cust_acct_sites ra

78:
79: BEGIN
80: SELECT ra.global_attribute8
81: INTO l_contributor_class_code
82: FROM hz_cust_acct_sites ra
83: WHERE ra.cust_acct_site_id = trx_lines_rec.orig_system_address_id;
84: arp_file.write_log('Contributor class code '||l_contributor_class_code);
85:
86: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 212: FROM hz_cust_acct_sites cas

208: IF l_contributor_class_code IS NOT NULL AND
209: l_tax_category_id IS NOT NULL THEN
210: SELECT nvl(cas.global_attribute9,'N')
211: INTO l_cus_cls_flag
212: FROM hz_cust_acct_sites cas
213: WHERE cas.cust_acct_site_id = trx_lines_rec.orig_system_address_id;
214: IF l_cus_cls_flag = 'Y' THEN
215: BEGIN
216: SELECT tax_attribute_name, tax_attribute_value