882: from hxc_mapping_components hmc,
883: hxc_alias_types hat,
884: hxc_alias_type_components hatc,
885: hxc_alias_definitions had,
886: hxc_bld_blk_info_type_usages bldu,
887: hxc_bld_blk_info_types bld
888: where had.alias_definition_id = p_alias_definition_id
889: and had.alias_type_id = hat.alias_type_id
890: and hatc.alias_type_id = hat.alias_type_id
985: from hxc_mapping_components hmc,
986: hxc_alias_types hat,
987: hxc_alias_type_components hatc,
988: hxc_alias_definitions had,
989: hxc_bld_blk_info_type_usages bldu,
990: hxc_bld_blk_info_types bld
991: where had.alias_definition_id = p_alias_definition_id
992: and had.alias_type_id = hat.alias_type_id
993: and hatc.alias_type_id = hat.alias_type_id