APPS.HXC_HAS_BUS dependencies on FND_TERRITORIES

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

420: -- |-----------------------< chk_legislation_code >----------------|
421: -- -----------------------------------------------------------------
422: --
423: -- Description:
424: -- Validate the legislation_code against the FND_TERRITORIES table.
425: --
426: -- Pre-Requisites:
427: -- None
428: --

Line 449: l_territory_code fnd_territories.territory_code%TYPE;

445: ) is
446: --
447: -- Local declarations
448: l_proc varchar2(72);
449: l_territory_code fnd_territories.territory_code%TYPE;
450: l_lc per_business_groups.legislation_code%TYPE;
451: --
452: -- Setup cursor for valid legislation code check
453: cursor csr_valid_legislation_code is

Line 455: from fnd_territories ft

451: --
452: -- Setup cursor for valid legislation code check
453: cursor csr_valid_legislation_code is
454: select territory_code
455: from fnd_territories ft
456: where ft.territory_code = p_legislation_code;
457:
458: -- Setup cursor for valid legislation code for a particular business_group
459: cursor csr_valid_bg_lc is