DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_EXC_CUS

Line 739: FROM jl_zz_ar_tx_exc_cus tec,

735: CURSOR c_cust_exc IS
736: SELECT tec.tax_code,
737: tec.base_rate,
738: tec.exc_cus_id
739: FROM jl_zz_ar_tx_exc_cus tec,
740: hz_cust_site_uses su
741: WHERE tec.tax_category_id = p_tax_category_id
742: AND p_trx_date <= tec.end_date_active
743: AND p_trx_date >= NVL(tec.start_date_active,p_trx_date)