eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_HR_LOCATIONS_GNR_HOOK dependencies on HZ_HIERARCHY_NODES

Line 99: FROM hz_hierarchy_nodes nodes, hz_geographies geo

95:
96: BEGIN
97: SELECT child_id
98: INTO l_geography_id_tbl(i)
99: FROM hz_hierarchy_nodes nodes, hz_geographies geo
100: WHERE parent_id = l_geography_id_tbl(i-1)
101: AND parent_object_type = l_geography_type(i-1)
102: AND child_object_type = l_geography_type(i)
103: AND nodes.child_id = geo.geography_id