162: -- |--------------------------< chk_legislation_code>-------------------------|
163: -- ----------------------------------------------------------------------------
164: --
165: -- Description:
166: -- Validates that the legislation code exists in fnd_territories
167: --
168: -- Pre-Requisites:
169: -- None
170: --
189: is
190: --
191: cursor csr_legislation_code is
192: select null
193: from fnd_territories
194: where territory_code = p_legislation_code ;
195: --
196: l_exists varchar2(1);
197: l_proc varchar2(100) := g_package || 'chk_legislation_code';