DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_NAT_RAT

Line 727: FROM jl_zz_ar_tx_nat_rat tnr,

723: CURSOR c_exc_trx_nature IS
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

Line 2175: FROM jl_zz_ar_tx_nat_rat

2171: min_taxable_basis
2172: INTO l_nat_min_tax_rate,
2173: l_nat_min_tax_amount,
2174: l_nat_min_taxable_base
2175: FROM jl_zz_ar_tx_nat_rat
2176: WHERE tax_categ_attr_val_id = trx_nature_rec.tax_categ_attr_val_id
2177: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2178: AND end_date_active;
2179: EXCEPTION