DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_EXC_CUS

Line 755: FROM jl_zz_ar_tx_exc_cus tec,

751: CURSOR c_cust_exc IS
752: SELECT tec.tax_code,
753: tec.base_rate,
754: tec.exc_cus_id
755: FROM jl_zz_ar_tx_exc_cus tec,
756: hz_cust_site_uses su
757: WHERE tec.tax_category_id = p_tax_category_id
758: AND p_trx_date <= tec.end_date_active
759: AND p_trx_date >= NVL(tec.start_date_active,p_trx_date)