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 2076: FROM jl_zz_ar_tx_cat_dtl

2072: IF NVL(p_min_tax_rate,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2073: BEGIN
2074: SELECT min_percentage
2075: INTO p_min_tax_rate
2076: FROM jl_zz_ar_tx_cat_dtl
2077: WHERE tax_category_id = p_tax_category_id
2078: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2079: AND end_date_active;
2080: EXCEPTION

Line 2099: FROM jl_zz_ar_tx_cat_dtl

2095: IF NVL(p_min_tax_amount,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2096: BEGIN
2097: SELECT min_amount
2098: INTO p_min_tax_amount
2099: FROM jl_zz_ar_tx_cat_dtl
2100: WHERE tax_category_id = p_tax_category_id
2101: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2102: AND end_date_active;
2103: EXCEPTION

Line 2122: FROM jl_zz_ar_tx_cat_dtl

2118: IF NVL(p_min_taxable_basis,0) = 0 AND l_use_tx_categ_thresholds = 'Y' THEN
2119: BEGIN
2120: SELECT min_taxable_basis
2121: INTO p_min_taxable_basis
2122: FROM jl_zz_ar_tx_cat_dtl
2123: WHERE tax_category_id = p_tax_category_id
2124: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2125: AND end_date_active;
2126: EXCEPTION