APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_CAT_ATT

Line 714: jl_zz_ar_tx_cat_att tca,

710: tnr.txn_nature_id
711: FROM jl_zz_ar_tx_nat_rat tnr,
712: jl_zz_ar_tx_att_val tcav,
713: jl_zz_ar_tx_categ tc,
714: jl_zz_ar_tx_cat_att tca,
715: jl_zz_ar_tx_att_cls tcac
716: WHERE tcac.tax_attr_class_code = p_transaction_nature_class
717: AND tcac.tax_category_id = p_tax_category_id
718: AND tcac.tax_attr_class_type = 'TRANSACTION_CLASS'

Line 1719: from jl_zz_ar_tx_cat_att ca

1715: AND ac.tax_category_id = p_tax_category_id
1716: AND ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
1717: AND ac.enabled_flag = 'Y'
1718: AND exists (select 1
1719: from jl_zz_ar_tx_cat_att ca
1720: WHERE ca.tax_category_id = ac.tax_category_id
1721: AND ca.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
1722: AND ca.tax_attribute_name = ac.tax_attribute_name);
1723:

Line 2009: jl_zz_ar_tx_cat_att tca,

2005: -- Bugfix 1388703
2006: CURSOR trx_nature IS
2007: SELECT tcav.tax_categ_attr_val_id tax_categ_attr_val_id
2008: FROM jl_zz_ar_tx_att_val tcav,
2009: jl_zz_ar_tx_cat_att tca,
2010: jl_zz_ar_tx_att_cls tcac
2011: WHERE tcav.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
2012: AND tcav.tax_category_id = p_tax_category_id
2013: AND tcac.tax_attr_class_code = p_transaction_nature_class