APPS.HXC_HPH_BUS dependencies on FND_TERRITORIES

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

1570: -- |-----------------------< chk_legislation_code >----------------|
1571: -- -----------------------------------------------------------------
1572: --
1573: -- Description:
1574: -- Validate the legislation_code against the FND_TERRITORIES table.
1575: --
1576: -- Pre-Requisites:
1577: -- None
1578: --

Line 1599: l_territory_code fnd_territories.territory_code%TYPE;

1595: ) is
1596: --
1597: -- Local declarations
1598: l_proc varchar2(72);
1599: l_territory_code fnd_territories.territory_code%TYPE;
1600: l_lc per_business_groups.legislation_code%TYPE;
1601: --
1602: -- Setup cursor for valid legislation code check
1603: cursor csr_valid_legislation_code is

Line 1605: from fnd_territories ft

1601: --
1602: -- Setup cursor for valid legislation code check
1603: cursor csr_valid_legislation_code is
1604: select territory_code
1605: from fnd_territories ft
1606: where ft.territory_code = p_legislation_code;
1607:
1608: -- Setup cursor for valid legislation code for a particular business_group
1609: cursor csr_valid_bg_lc is