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.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 69: FROM hz_geo_structure_levels

65:
66: BEGIN
67:
68: SELECT 1 into l_count
69: FROM hz_geo_structure_levels
70: WHERE geography_id = l_geography_id
71: AND rownum <2;
72:
73: IF l_count = 0 THEN

Line 84: FROM HZ_GEO_STRUCTURE_LEVELS

80: -- check whether geography_type and parent_geography_type are as per the country structure
81: /*SELECT 1 into l_count
82: FROM dual
83: WHERE p_geography_type in (SELECT geography_type
84: FROM HZ_GEO_STRUCTURE_LEVELS
85: WHERE country_code = p_country_code
86: CONNECT BY PRIOR geography_type=parent_geography_type
87: START WITH parent_geography_type = p_parent_geography_type); */
88:

Line 92: FROM hz_geo_structure_levels

88:
89: -- changing the above validation as fix for 2917924
90:
91: SELECT 1 into l_count
92: FROM hz_geo_structure_levels
93: WHERE geography_id=l_geography_id
94: and geography_type=p_geography_type
95: and parent_geography_type=p_parent_geography_type;
96: