DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_JURISDICTIONS_GT

Line 188: ----- Add logic to use zx_jurisdictions_gt table

184: -- If found pass it back to TDM
185: -- End if;
186: -- End if;
187: -- End if;
188: ----- Add logic to use zx_jurisdictions_gt table
189: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
191: END IF;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 215: FROM zx_jurisdictions_gt

211: l_tax_jurisdiction_id_tbl(1) := p_tax_jurisdiction_id;
212: ELSE
213: SELECT tax_jurisdiction_id
214: BULK COLLECT INTO l_tax_jurisdiction_id_tbl
215: FROM zx_jurisdictions_gt
216: ORDER BY precedence_level;
217: END IF;
218:
219: FOR i in l_tax_jurisdiction_id_tbl.first..l_tax_jurisdiction_id_tbl.last LOOP