1038: UNION
1039: SELECT rt.object_type geography_type,
1040: gt.geography_use geography_use,
1041: 2+rownum geography_type_num
1042: FROM hz_relationship_types rt,
1043: hz_geography_types_b gt
1044: WHERE l_tax_rec.override_geography_type = rt.subject_type
1045: AND rt.object_type = gt.geography_type)
1046: ORDER BY 3 desc;