APPS.HXC_ALIAS_UTILITY dependencies on HXC_BLD_BLK_INFO_TYPES

Line 56: hxc_bld_blk_info_types bld

52: hxc_alias_types hat,
53: hxc_alias_type_components hatc,
54: hxc_alias_definitions had,
55: hxc_bld_blk_info_type_usages bldu,
56: hxc_bld_blk_info_types bld
57: where had.alias_definition_id = 1
58: and had.alias_type_id = hat.alias_type_id
59: and hatc.alias_type_id = hat.alias_type_id
60: and hmc.mapping_component_id = hatc.mapping_component_id

Line 1096: hxc_bld_blk_info_types bld

1092: hxc_alias_types hat,
1093: hxc_alias_type_components hatc,
1094: hxc_alias_definitions had,
1095: hxc_bld_blk_info_type_usages bldu,
1096: hxc_bld_blk_info_types bld
1097: where had.alias_definition_id = p_alias_definition_id
1098: and had.alias_type_id = hat.alias_type_id
1099: and hatc.alias_type_id = hat.alias_type_id
1100: and hmc.mapping_component_id = hatc.mapping_component_id

Line 1252: hxc_bld_blk_info_types bld

1248: hxc_alias_types hat,
1249: hxc_alias_type_components hatc,
1250: hxc_alias_definitions had,
1251: hxc_bld_blk_info_type_usages bldu,
1252: hxc_bld_blk_info_types bld
1253: where had.alias_definition_id = p_alias_definition_id
1254: and had.alias_type_id = hat.alias_type_id
1255: and hatc.alias_type_id = hat.alias_type_id
1256: and hmc.mapping_component_id = hatc.mapping_component_id

Line 5418: FROM hxc_bld_blk_info_types

5414: FUNCTION get_bld_blk_type_id(p_type IN varchar2) RETURN NUMBER IS
5415:
5416: CURSOR csr_bld_blk_id(p_type IN varchar2) IS
5417: SELECT bld_blk_info_type_id
5418: FROM hxc_bld_blk_info_types
5419: WHERE bld_blk_info_type = p_type;
5420:
5421: l_type_id NUMBER;
5422:

Line 5670: from hxc_bld_blk_info_types bbit,

5666: ,'N' NEW
5667: ,'N' CHANGED
5668: ,'N' PROCESS
5669: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5670: from hxc_bld_blk_info_types bbit,
5671: hxc_time_attribute_usages au,
5672: hxc_time_attributes a,
5673: hxc_time_building_blocks htbb
5674: where a.time_attribute_id = au.time_attribute_id

Line 5727: from hxc_bld_blk_info_types bbit,

5723: ,'N' NEW
5724: ,'N' CHANGED
5725: ,'N' PROCESS
5726: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5727: from hxc_bld_blk_info_types bbit,
5728: hxc_time_attribute_usages au,
5729: hxc_time_attributes a,
5730: hxc_time_building_blocks htbb
5731: where a.time_attribute_id = au.time_attribute_id