[Home] [Help]
1739: select ota.tax_attribute_value,
1740: cta.tax_attribute_value
1741: into l_establishment_type,
1742: l_contributor_type
1743: FROM jl_zz_ar_tx_cus_cls cta,
1744: hz_cust_site_uses rsu,
1745: jl_zz_ar_tx_att_cls ota,
1746: jl_zz_ar_tx_categ tc
1747: WHERE tc.tax_category_id = p_tax_category_id
3494: -- Bugfix 1783986. Added if and else conditions
3495: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3496: select ac.tax_attribute_value
3497: into v_aux_contributor_type
3498: from jl_zz_ar_tx_cus_cls ac,
3499: hz_cust_site_uses su,
3500: jl_zz_ar_tx_categ cat
3501: where ac.tax_attr_class_code = p_contributor_class
3502: and ac.tax_category_id = v_tax_category_to_reduce_id