156: l_tax_category_id IS NOT NULL THEN
157: BEGIN
158: SELECT tax_attribute_name, tax_attribute_value
159: INTO l_org_attribute_name, l_org_attribute_value
160: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ_all cat
161: WHERE cls.tax_attr_class_type = 'ORGANIZATION_CLASS'
162: AND cls.tax_attr_class_code = l_organization_class_code
163: AND cls.tax_category_id = l_tax_category_id
164: AND cls.tax_category_id = cat.tax_category_id
212: ELSE
213: BEGIN
214: SELECT tax_attribute_name, tax_attribute_value
215: INTO l_cust_attribute_name, l_cust_attribute_value
216: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ_all cat
217: WHERE att.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
218: AND att.tax_attr_class_code = l_contributor_class_code
219: AND att.tax_category_id = l_tax_category_id
220: AND att.tax_attribute_name = cat.cus_tax_attribute