APPS.HRFASTANSWERS dependencies on BIS_TERRITORY_HIERARCHIES_V

Line 1764: from bis_territory_hierarchies_v ter

1760: -- value of Unassigned. This will stop it going on down
1761: -- to the next level as it's found a record
1762: cursor get_area is
1763: select nvl(ter.parent_territory_code,'Unassigned')
1764: from bis_territory_hierarchies_v ter
1765: , hr_locations loc
1766: where ter.child_territory_code(+) = loc.country
1767: and decode(ter.parent_territory_type,null,'AREA'
1768: ,ter.parent_territory_type) = 'AREA'

Line 1774: from bis_territory_hierarchies_v ter

1770:
1771: -- Then look at location on the position
1772: cursor get_area_pos is
1773: select nvl(ter.parent_territory_code, 'Unassigned')
1774: from bis_territory_hierarchies_v ter
1775: , hr_locations loc
1776: , per_positions pos
1777: where ter.child_territory_code(+) = loc.country
1778: and decode(ter.parent_territory_type,null,'AREA'

Line 1786: from bis_territory_hierarchies_v ter

1782:
1783: -- Then look at location on the organization
1784: cursor get_area_org is
1785: select nvl(ter.parent_territory_code, 'Unassigned')
1786: from bis_territory_hierarchies_v ter
1787: , hr_locations loc
1788: , hr_organization_units hou
1789: where ter.child_territory_code(+) = loc.country
1790: and decode(ter.parent_territory_type,null,'AREA'

Line 1800: from bis_territory_hierarchies_v ter

1796: -- NB. Doesn't matter if don't find Unassigned here as
1797: -- don't want to drill any further
1798: cursor get_area_bus is
1799: select ter.parent_territory_code
1800: from bis_territory_hierarchies_v ter
1801: , hr_locations loc
1802: , per_business_groups bgr
1803: where ter.child_territory_code = loc.country
1804: and ter.parent_territory_type = 'AREA'