181: l_tax_category_id IS NOT NULL THEN
182: BEGIN
183: SELECT tax_attribute_name, tax_attribute_value
184: INTO l_org_attribute_name, l_org_attribute_value
185: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ cat
186: WHERE cls.tax_attr_class_type = 'ORGANIZATION_CLASS'
187: AND cls.tax_attr_class_code = l_organization_class_code
188: AND cls.tax_category_id = l_tax_category_id
189: AND cls.tax_category_id = cat.tax_category_id
237: ELSE
238: BEGIN
239: SELECT tax_attribute_name, tax_attribute_value
240: INTO l_cust_attribute_name, l_cust_attribute_value
241: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ cat
242: WHERE att.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
243: AND att.tax_attr_class_code = l_contributor_class_code
244: AND att.tax_category_id = l_tax_category_id
245: AND att.tax_attribute_name = cat.cus_tax_attribute