APPS.HXC_ALIAS_UTILITY dependencies on HXC_BLD_BLK_INFO_TYPES

Line 887: hxc_bld_blk_info_types bld

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
891: and hmc.mapping_component_id = hatc.mapping_component_id

Line 990: hxc_bld_blk_info_types bld

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
994: and hmc.mapping_component_id = hatc.mapping_component_id

Line 5102: FROM hxc_bld_blk_info_types

5098: FUNCTION get_bld_blk_type_id(p_type IN varchar2) RETURN NUMBER IS
5099:
5100: CURSOR csr_bld_blk_id(p_type IN varchar2) IS
5101: SELECT bld_blk_info_type_id
5102: FROM hxc_bld_blk_info_types
5103: WHERE bld_blk_info_type = p_type;
5104:
5105: l_type_id NUMBER;
5106:

Line 5354: from hxc_bld_blk_info_types bbit,

5350: ,'N' NEW
5351: ,'N' CHANGED
5352: ,'N' PROCESS
5353: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5354: from hxc_bld_blk_info_types bbit,
5355: hxc_time_attribute_usages au,
5356: hxc_time_attributes a,
5357: hxc_time_building_blocks htbb
5358: where a.time_attribute_id = au.time_attribute_id

Line 5411: from hxc_bld_blk_info_types bbit,

5407: ,'N' NEW
5408: ,'N' CHANGED
5409: ,'N' PROCESS
5410: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5411: from hxc_bld_blk_info_types bbit,
5412: hxc_time_attribute_usages au,
5413: hxc_time_attributes a,
5414: hxc_time_building_blocks htbb
5415: where a.time_attribute_id = au.time_attribute_id