1381: )
1382: IS
1383: SELECT mc.bld_blk_info_type_id
1384: FROM hxc_mapping_components mc
1385: ,hxc_mapping_comp_usages mcu
1386: ,hxc_mappings m
1387: ,hxc_retrieval_processes rp
1388: WHERE upper(mc.field_name) = upper(p_field_name)
1389: AND rp.mapping_id = m.mapping_id
1524: )
1525: IS
1526: select mc.segment
1527: from hxc_mapping_components mc
1528: ,hxc_mapping_comp_usages mcu
1529: ,hxc_mappings m
1530: ,hxc_retrieval_processes rp
1531: ,hxc_bld_blk_info_types bbit
1532: ,hxc_bld_blk_info_type_usages bbui