APPS.HXC_HAD_BUS dependencies on FND_TERRITORIES

Line 453: -- Validate the legislation_code against the FND_TERRITORIES table.

449: -- |-----------------------< chk_legislation_code >----------------|
450: -- -----------------------------------------------------------------
451: --
452: -- Description:
453: -- Validate the legislation_code against the FND_TERRITORIES table.
454: --
455: -- Pre-Requisites:
456: -- None
457: --

Line 478: l_territory_code fnd_territories.territory_code%TYPE;

474: ) is
475: --
476: -- Local declarations
477: l_proc varchar2(72);
478: l_territory_code fnd_territories.territory_code%TYPE;
479: l_lc per_business_groups.legislation_code%TYPE;
480: --
481: -- Setup cursor for valid legislation code check
482: cursor csr_valid_legislation_code is

Line 484: from fnd_territories ft

480: --
481: -- Setup cursor for valid legislation code check
482: cursor csr_valid_legislation_code is
483: select territory_code
484: from fnd_territories ft
485: where ft.territory_code = p_legislation_code;
486:
487: -- Setup cursor for valid legislation code for a particular business_group
488: cursor csr_valid_bg_lc is