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 187: FROM hz_cust_acct_sites cas

183: IF l_contributor_class_code IS NOT NULL AND
184: l_tax_category_id IS NOT NULL THEN
185: SELECT nvl(cas.global_attribute9,'N')
186: INTO l_cus_cls_flag
187: FROM hz_cust_acct_sites cas
188: WHERE cas.cust_acct_site_id = trx_lines_rec.orig_system_address_id;
189: IF l_cus_cls_flag = 'Y' THEN
190: BEGIN
191: SELECT tax_attribute_name, tax_attribute_value