1153: UNION
1154: SELECT rt.object_type geography_type,
1155: gt.geography_use geography_use,
1156: 2+rownum geography_type_num
1157: FROM hz_relationship_types rt,
1158: hz_geography_types_b gt
1159: WHERE l_tax_rec.override_geography_type = rt.subject_type
1160: AND rt.object_type = gt.geography_type)
1161: ORDER BY 3 desc;
1198: IF g_geography_use_info_tbl(l_tbl_index).geography_use = 'TAX' THEN
1199: BEGIN
1200: SELECT object_type geography_type
1201: INTO l_obj_geo_type
1202: FROM hz_relationship_types
1203: WHERE subject_type = g_geography_use_info_tbl(l_tbl_index).geography_type
1204: AND object_type = 'CITY';
1205: EXCEPTION
1206: WHEN OTHERS THEN