APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1196: delete from zx_jurisdictions_gt;

1192: pg_exempt_reason_tab ,
1193: pg_exempt_cont_flag_tab
1194: limit C_LINES_PER_COMMIT;/*Need to limit the fetch*/
1195:
1196: delete from zx_jurisdictions_gt;
1197:
1198: IF (nvl(pg_trx_id_tab.last,0) = 0) Then
1199: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1779: FROM zx_jurisdictions_gt

1775: SELECT tax_jurisdiction_code
1776: INTO x_tax_jurisdiction_code
1777: FROM
1778: (SELECT tax_jurisdiction_code
1779: FROM zx_jurisdictions_gt
1780: WHERE tax_regime_code = p_regime_code
1781: AND tax = p_tax
1782: AND precedence_level = (SELECT max(precedence_level)
1783: FROM zx_jurisdictions_gt

Line 1783: FROM zx_jurisdictions_gt

1779: FROM zx_jurisdictions_gt
1780: WHERE tax_regime_code = p_regime_code
1781: AND tax = p_tax
1782: AND precedence_level = (SELECT max(precedence_level)
1783: FROM zx_jurisdictions_gt
1784: WHERE tax_regime_code = p_regime_code
1785: AND tax = p_tax)
1786: ORDER BY tax_jurisdiction_code)
1787: WHERE ROWNUM = 1;