APPS.ZX_JL_EXTRACT_PKG dependencies on AR_VAT_TAX_ALL

Line 2588: ar_vat_tax_all vat

2584: dtl.tax_rate_id,
2585: null document_sub_type,
2586: dtl.tax_regime_code
2587: FROM zx_rep_trx_detail_t dtl,
2588: ar_vat_tax_all vat
2589: WHERE dtl.request_id = P_REQUEST_ID
2590: AND nvl(vat.tax_type,'VAT') = 'VAT'
2591: AND dtl.tax_rate_id = vat.vat_tax_id
2592: -- AND dtl.doc_event_status = 'FROZEN_FOR_TAX'

Line 4021: ar_vat_tax_all vat

4017:
4018: SELECT sum(nvl(itf.tax_amt_funcl_curr, itf.tax_amt))
4019: INTO l_vat_amt_tbl(p_trx_id_tbl(i))
4020: FROM zx_rep_trx_detail_t itf,
4021: ar_vat_tax_all vat
4022: WHERE itf.request_id = p_request_id
4023: AND itf.trx_id = p_trx_id_tbl(i)
4024: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)
4025: AND itf.tax_regime_code = p_tax_regime

Line 9234: FROM ar_vat_tax_all

9230: WHEN NO_DATA_FOUND THEN
9231: X_PROV_JURIS_CODE_TBL(i) := NULL; */
9232: SELECT global_attribute5
9233: INTO l_prov_juris_code_tbl(p_tax_rate_id_tbl(i))
9234: FROM ar_vat_tax_all
9235: WHERE VAT_TAX_ID = P_TAX_RATE_ID_TBL(i);
9236:
9237: X_PROV_JURIS_CODE_TBL(i) := l_prov_juris_code_tbl(p_tax_rate_id_tbl(i));
9238:

Line 9336: FROM ar_vat_tax_all

9332: X_MUN_JURIS_CODE_TBL(i) := NULL; */
9333:
9334: SELECT global_attribute6
9335: INTO l_mun_juris_code_tbl(p_tax_rate_id_tbl(i))
9336: FROM ar_vat_tax_all
9337: WHERE VAT_TAX_ID = P_TAX_RATE_ID_TBL(i);
9338:
9339: IF ( g_level_statement>= g_current_runtime_level ) THEN
9340: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.MUN_JURISDICTION_CODE',