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: --
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
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