DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_CUS_CLS

Line 1763: FROM jl_zz_ar_tx_cus_cls cta,

1759: select ota.tax_attribute_value,
1760: cta.tax_attribute_value
1761: into l_establishment_type,
1762: l_contributor_type
1763: FROM jl_zz_ar_tx_cus_cls cta,
1764: hz_cust_site_uses rsu,
1765: jl_zz_ar_tx_att_cls ota,
1766: jl_zz_ar_tx_categ tc
1767: WHERE tc.tax_category_id = p_tax_category_id

Line 3576: from jl_zz_ar_tx_cus_cls ac,

3572: -- Bugfix 1783986. Added if and else conditions
3573: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3574: select ac.tax_attribute_value
3575: into v_aux_contributor_type
3576: from jl_zz_ar_tx_cus_cls ac,
3577: hz_cust_site_uses su,
3578: jl_zz_ar_tx_categ cat
3579: where ac.tax_attr_class_code = p_contributor_class
3580: and ac.tax_category_id = v_tax_category_to_reduce_id