481: -- |--------------------------< chk_legislation_code>-------------------------|
482: -- ----------------------------------------------------------------------------
483: --
484: -- Description:
485: -- Validates that the legislation code exists in fnd_territories
486: --
487: -- Pre-Requisites:
488: -- None
489: --
508: is
509: --
510: cursor csr_legislation_code is
511: select null
512: from fnd_territories
513: where territory_code = p_legislation_code ;
514: --
515: l_exists varchar2(1);
516: l_proc varchar2(100) := g_package || 'chk_legislation_code';