DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_NAT_RAT

Line 711: FROM jl_zz_ar_tx_nat_rat tnr,

707: CURSOR c_exc_trx_nature IS
708: SELECT tnr.tax_code,
709: tnr.base_rate,
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

Line 2155: FROM jl_zz_ar_tx_nat_rat

2151: min_taxable_basis
2152: INTO l_nat_min_tax_rate,
2153: l_nat_min_tax_amount,
2154: l_nat_min_taxable_base
2155: FROM jl_zz_ar_tx_nat_rat
2156: WHERE tax_categ_attr_val_id = trx_nature_rec.tax_categ_attr_val_id
2157: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2158: AND end_date_active;
2159: EXCEPTION