DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_SCHEDULES

Line 583: FROM jl_zz_ar_tx_schedules

579: CURSOR c_tax_schedule IS
580: SELECT tax_code,
581: NULL,
582: NULL
583: FROM jl_zz_ar_tx_schedules
584: WHERE tax_category_id = p_tax_category_id
585: AND p_base_amount BETWEEN min_taxable_basis
586: AND max_taxable_basis
587: AND p_trx_date <= end_date_active

Line 2805: FROM jl_zz_ar_tx_schedules

2801: CURSOR tax_schedule IS
2802: SELECT tax_code,
2803: min_taxable_basis,
2804: max_taxable_basis
2805: FROM jl_zz_ar_tx_schedules
2806: WHERE tax_category_id = p_tax_category_id
2807: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2808: AND end_date_active;
2809: