APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_CAT_DTL

Line 259: FROM jl_zz_ar_tx_cat_dtl cat

255: CURSOR c_category IS
256: SELECT cat.tax_code,
257: NULL,
258: NULL
259: FROM jl_zz_ar_tx_cat_dtl cat
260: WHERE cat.tax_category_id = p_tax_category_id
261: AND p_trx_date <= cat.end_date_active
262: AND p_trx_date >= NVL(cat.start_date_active,p_trx_date)
263: UNION

Line 2096: FROM jl_zz_ar_tx_cat_dtl

2092: IF NVL(p_min_tax_rate,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2093: BEGIN
2094: SELECT min_percentage
2095: INTO p_min_tax_rate
2096: FROM jl_zz_ar_tx_cat_dtl
2097: WHERE tax_category_id = p_tax_category_id
2098: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2099: AND end_date_active;
2100: EXCEPTION

Line 2119: FROM jl_zz_ar_tx_cat_dtl

2115: IF NVL(p_min_tax_amount,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2116: BEGIN
2117: SELECT min_amount
2118: INTO p_min_tax_amount
2119: FROM jl_zz_ar_tx_cat_dtl
2120: WHERE tax_category_id = p_tax_category_id
2121: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2122: AND end_date_active;
2123: EXCEPTION

Line 2142: FROM jl_zz_ar_tx_cat_dtl

2138: IF NVL(p_min_taxable_basis,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2139: BEGIN
2140: SELECT min_taxable_basis
2141: INTO p_min_taxable_basis
2142: FROM jl_zz_ar_tx_cat_dtl
2143: WHERE tax_category_id = p_tax_category_id
2144: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2145: AND end_date_active;
2146: EXCEPTION