APPS.HR_AHK_BUS dependencies on FND_TERRITORIES

Line 274: -- Checks that the legislation_code is valid against the FND_TERRITORIES table.

270: -- |-----------------------< chk_legislation_code >----------------|
271: -- -----------------------------------------------------------------
272: --
273: -- Description:
274: -- Checks that the legislation_code is valid against the FND_TERRITORIES table.
275: --
276: -- Pre-Requisites:
277: -- None
278: --

Line 300: l_territory_code fnd_territories.territory_code%TYPE;

296: ) is
297: --
298: -- Local declarations
299: l_proc varchar2(72) := g_package||'chk_legislation_code';
300: l_territory_code fnd_territories.territory_code%TYPE;
301: --
302: -- Setup cursor for valid legislation code check
303: cursor csr_valid_legislation_code is
304: select territory_code

Line 305: from fnd_territories ft

301: --
302: -- Setup cursor for valid legislation code check
303: cursor csr_valid_legislation_code is
304: select territory_code
305: from fnd_territories ft
306: where ft.territory_code = p_legislation_code;
307:
308: --
309: --