DBA Data[Home] [Help]

APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 1157: FROM hz_relationship_types rt,

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;

Line 1202: FROM hz_relationship_types

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