213: -- |-----------------------< chk_legislation_code >----------------|
214: -- -----------------------------------------------------------------
215: --
216: -- Description:
217: -- Validate the legislation_code against the FND_TERRITORIES table.
218: --
219: -- Pre-Requisites:
220: -- None
221: --
239: ) is
240: --
241: -- Local declarations
242: l_proc varchar2(72) := g_package||'chk_legislation_code';
243: l_territory_code fnd_territories.territory_code%TYPE;
244: --
245: -- Setup cursor for valid legislation code check
246: cursor csr_valid_legislation_code is
247: select territory_code
244: --
245: -- Setup cursor for valid legislation code check
246: cursor csr_valid_legislation_code is
247: select territory_code
248: from fnd_territories ft
249: where ft.territory_code = p_legislation_code;
250: --
251: --
252: begin