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_GEOGRAPHIES

Line 75: FROM hz_geographies

71: ORDER BY map_dtl.loc_seq_num;
72:
73: SELECT geography_id
74: INTO l_country_geography_id
75: FROM hz_geographies
76: WHERE geography_type = 'COUNTRY'
77: AND geography_code = p_country;
78:
79: FOR i IN l_loc_component_tbl.first..l_loc_component_tbl.last LOOP

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