DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_SCHEDULES

Line 590: FROM jl_zz_ar_tx_schedules

586: CURSOR c_tax_schedule IS
587: SELECT tax_code,
588: NULL,
589: NULL
590: FROM jl_zz_ar_tx_schedules
591: WHERE tax_category_id = p_tax_category_id
592: AND p_base_amount BETWEEN min_taxable_basis
593: AND max_taxable_basis
594: AND p_trx_date <= end_date_active

Line 2827: FROM jl_zz_ar_tx_schedules

2823: CURSOR tax_schedule IS
2824: SELECT tax_code,
2825: min_taxable_basis,
2826: max_taxable_basis
2827: FROM jl_zz_ar_tx_schedules
2828: WHERE tax_category_id = p_tax_category_id
2829: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2830: AND end_date_active;
2831: