APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1208: delete from zx_jurisdictions_gt;

1204: pg_exempt_reason_tab ,
1205: pg_exempt_cont_flag_tab
1206: limit C_LINES_PER_COMMIT;/*Need to limit the fetch*/
1207:
1208: delete from zx_jurisdictions_gt;
1209: l_index := 0;
1210: IF (nvl(pg_trx_id_tab.last,0) = 0) Then
1211: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1809: FROM zx_jurisdictions_gt

1805: SELECT tax_jurisdiction_code
1806: INTO x_tax_jurisdiction_code
1807: FROM
1808: (SELECT tax_jurisdiction_code
1809: FROM zx_jurisdictions_gt
1810: WHERE tax_regime_code = p_regime_code
1811: AND tax = p_tax
1812: AND precedence_level = (SELECT max(precedence_level)
1813: FROM zx_jurisdictions_gt

Line 1813: FROM zx_jurisdictions_gt

1809: FROM zx_jurisdictions_gt
1810: WHERE tax_regime_code = p_regime_code
1811: AND tax = p_tax
1812: AND precedence_level = (SELECT max(precedence_level)
1813: FROM zx_jurisdictions_gt
1814: WHERE tax_regime_code = p_regime_code
1815: AND tax = p_tax)
1816: ORDER BY tax_jurisdiction_code)
1817: WHERE ROWNUM = 1;