APPS.HXC_HAD_BUS dependencies on FND_TERRITORIES

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

415: -- |-----------------------< chk_legislation_code >----------------|
416: -- -----------------------------------------------------------------
417: --
418: -- Description:
419: -- Validate the legislation_code against the FND_TERRITORIES table.
420: --
421: -- Pre-Requisites:
422: -- None
423: --

Line 444: l_territory_code fnd_territories.territory_code%TYPE;

440: ) is
441: --
442: -- Local declarations
443: l_proc varchar2(72);
444: l_territory_code fnd_territories.territory_code%TYPE;
445: l_lc per_business_groups.legislation_code%TYPE;
446: --
447: -- Setup cursor for valid legislation code check
448: cursor csr_valid_legislation_code is

Line 450: from fnd_territories ft

446: --
447: -- Setup cursor for valid legislation code check
448: cursor csr_valid_legislation_code is
449: select territory_code
450: from fnd_territories ft
451: where ft.territory_code = p_legislation_code;
452:
453: -- Setup cursor for valid legislation code for a particular business_group
454: cursor csr_valid_bg_lc is