APPS.ZX_JL_EXTRACT_PKG dependencies on AR_VAT_TAX_ALL

Line 2561: ar_vat_tax_all vat

2557: dtl.tax_rate_id,
2558: null document_sub_type,
2559: dtl.tax_regime_code
2560: FROM zx_rep_trx_detail_t dtl,
2561: ar_vat_tax_all vat
2562: WHERE dtl.request_id = P_REQUEST_ID
2563: AND nvl(vat.tax_type,'VAT') = 'VAT'
2564: AND dtl.tax_rate_id = vat.vat_tax_id
2565: -- AND dtl.doc_event_status = 'FROZEN_FOR_TAX'

Line 3931: ar_vat_tax_all vat

3927:
3928: SELECT sum(nvl(itf.tax_amt_funcl_curr, itf.tax_amt))
3929: INTO l_vat_amt_tbl(p_trx_id_tbl(i))
3930: FROM zx_rep_trx_detail_t itf,
3931: ar_vat_tax_all vat
3932: WHERE itf.request_id = p_request_id
3933: AND itf.trx_id = p_trx_id_tbl(i)
3934: AND itf.detail_tax_line_id = p_detail_tax_line_id(i)
3935: AND itf.tax_regime_code = p_tax_regime

Line 8726: FROM ar_vat_tax_all

8722: WHEN NO_DATA_FOUND THEN
8723: X_PROV_JURIS_CODE_TBL(i) := NULL; */
8724: SELECT global_attribute5
8725: INTO l_prov_juris_code_tbl(p_tax_rate_id_tbl(i))
8726: FROM ar_vat_tax_all
8727: WHERE VAT_TAX_ID = P_TAX_RATE_ID_TBL(i);
8728:
8729: X_PROV_JURIS_CODE_TBL(i) := l_prov_juris_code_tbl(p_tax_rate_id_tbl(i));
8730:

Line 8828: FROM ar_vat_tax_all

8824: X_MUN_JURIS_CODE_TBL(i) := NULL; */
8825:
8826: SELECT global_attribute6
8827: INTO l_mun_juris_code_tbl(p_tax_rate_id_tbl(i))
8828: FROM ar_vat_tax_all
8829: WHERE VAT_TAX_ID = P_TAX_RATE_ID_TBL(i);
8830:
8831: IF ( g_level_statement>= g_current_runtime_level ) THEN
8832: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.MUN_JURISDICTION_CODE',