[Home] [Help]
78: , bbit.bld_blk_info_type context
79: , bbitu.building_block_category category
80: FROM
81: hxc_bld_blk_info_type_usages bbitu
82: , hxc_bld_blk_info_types bbit
83: , hxc_mapping_components mpc
84: , hxc_mapping_comp_usages mcu
85: , hxc_mappings map
86: WHERE map.mapping_id = p_mapping_id
728: FROM
729: hxc_time_building_blocks bb
730: , hxc_time_attributes ta
731: , hxc_time_attribute_usages tau
732: , hxc_bld_blk_info_types bbit
733: WHERE
734: bb.time_building_block_id = p_bb_id AND
735: bb.object_version_number = p_bb_ovn
736: AND
813: FROM
814: hxc_time_attributes ta
815: , hxc_time_attribute_usages tau
816: , hxc_time_building_blocks bb
817: , hxc_bld_blk_info_types bbit
818: WHERE
819: bb.time_building_block_id = p_bb_id AND
820: bb.object_version_number = p_decr_ovn AND
821: bb.approval_status = p_status
1919:
1920: cursor c_map is
1921: select hmc.segment
1922: from hxc_mapping_components hmc,
1923: hxc_bld_blk_info_types hit
1924: where hit.descriptive_flexfield_name = p_descriptive_flexfield_name
1925: and hit.bld_blk_info_type_id = hmc.bld_blk_info_type_id
1926: and hit.bld_blk_info_type = p_bld_blk_info_type
1927: and hmc.field_name = p_field_name;
1986: from hxc_mapping_components hmc
1987: , hxc_mapping_comp_usages hmu
1988: , hxc_mappings hmp
1989: , hxc_retrieval_processes hrp
1990: , hxc_bld_blk_info_types hit
1991: where hmu.mapping_id = hmp.mapping_id
1992: and hmp.mapping_id = hrp.mapping_id
1993: and hmc.bld_blk_info_type_id = hit.bld_blk_info_type_id
1994: and hrp.retrieval_process_id = p_process_id
2000: from hxc_mapping_components hmc
2001: , hxc_mapping_comp_usages hmu
2002: , hxc_mappings hmp
2003: , hxc_deposit_processes hdp
2004: , hxc_bld_blk_info_types hit
2005: where hmu.mapping_id = hmp.mapping_id
2006: and hmp.mapping_id = hdp.mapping_id
2007: and hmc.bld_blk_info_type_id = hit.bld_blk_info_type_id
2008: and hdp.deposit_process_id = p_process_id