DBA Data[Home] [Help]

APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 1042: FROM hz_relationship_types rt,

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;