DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_ATT_VAL

Line 728: jl_zz_ar_tx_att_val tcav,

724: SELECT tnr.tax_code,
725: tnr.base_rate,
726: tnr.txn_nature_id
727: FROM jl_zz_ar_tx_nat_rat tnr,
728: jl_zz_ar_tx_att_val tcav,
729: jl_zz_ar_tx_categ tc,
730: jl_zz_ar_tx_cat_att tca,
731: jl_zz_ar_tx_att_cls tcac
732: WHERE tcac.tax_attr_class_code = p_transaction_nature_class

Line 2028: FROM jl_zz_ar_tx_att_val tcav,

2024:
2025: -- Bugfix 1388703
2026: CURSOR trx_nature IS
2027: SELECT tcav.tax_categ_attr_val_id tax_categ_attr_val_id
2028: FROM jl_zz_ar_tx_att_val tcav,
2029: jl_zz_ar_tx_cat_att tca,
2030: jl_zz_ar_tx_att_cls tcac
2031: WHERE tcav.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
2032: AND tcav.tax_category_id = p_tax_category_id