APPS.HXC_HRR_BUS dependencies on FND_TERRITORIES

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

474: -- |-----------------------< chk_legislation_code >----------------|
475: -- -----------------------------------------------------------------
476: --
477: -- Description:
478: -- Validate the legislation_code against the FND_TERRITORIES table.
479: --
480: -- Pre-Requisites:
481: -- None
482: --

Line 503: l_territory_code fnd_territories.territory_code%TYPE;

499: ) is
500: --
501: -- Local declarations
502: l_proc varchar2(72);
503: l_territory_code fnd_territories.territory_code%TYPE;
504: l_lc per_business_groups.legislation_code%TYPE;
505: --
506: -- Setup cursor for valid legislation code check
507: cursor csr_valid_legislation_code is

Line 509: from fnd_territories ft

505: --
506: -- Setup cursor for valid legislation code check
507: cursor csr_valid_legislation_code is
508: select territory_code
509: from fnd_territories ft
510: where ft.territory_code = p_legislation_code;
511:
512: -- Setup cursor for valid legislation code for a particular business_group
513: cursor csr_valid_bg_lc is