APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_HIERARCHY_NODES

Line 1121: delete hz_hierarchy_nodes

1117: and (relationship_type = 'TAX'
1118: or relationship_type = 'MASTER_REF');
1119:
1120: -- delete hierarchy nodes record for master_ref geos
1121: delete hz_hierarchy_nodes
1122: where (parent_id = l_geography_id
1123: or child_id = l_geography_id)
1124: and parent_table_name = 'HZ_GEOGRAPHIES'
1125: and child_table_name = 'HZ_GEOGRAPHIES'