APPS.HXC_TER_BUS dependencies on FND_TERRITORIES

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

930: -- |-----------------------< chk_legislation_code >----------------|
931: -- -----------------------------------------------------------------
932: --
933: -- Description:
934: -- Validate the legislation_code against the FND_TERRITORIES table.
935: --
936: -- Pre-Requisites:
937: -- None
938: --

Line 959: l_territory_code fnd_territories.territory_code%TYPE;

955: ) is
956: --
957: -- Local declarations
958: l_proc varchar2(72);
959: l_territory_code fnd_territories.territory_code%TYPE;
960: l_lc per_business_groups.legislation_code%TYPE;
961: --
962: -- Setup cursor for valid legislation code check
963: cursor csr_valid_legislation_code is

Line 965: from fnd_territories ft

961: --
962: -- Setup cursor for valid legislation code check
963: cursor csr_valid_legislation_code is
964: select territory_code
965: from fnd_territories ft
966: where ft.territory_code = p_legislation_code;
967:
968: -- Setup cursor for valid legislation code for a particular business_group
969: cursor csr_valid_bg_lc is