DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_LOCN

Line 608: FROM jl_zz_ar_tx_locn loc

604: CURSOR c_location IS
605: SELECT loc.tax_code,
606: loc.base_rate,
607: loc.locn_id
608: FROM jl_zz_ar_tx_locn loc
609: WHERE loc.tax_category_id = p_tax_category_id
610: AND p_trx_date <= loc.end_date_active
611: AND p_trx_date >= NVL(loc.start_date_active, p_trx_date)
612: AND exists (select 1