APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

79: and htau.time_attribute_id = hta.time_attribute_id
80: and hta.attribute_category = :p_context';
81: else
82: l_query := l_query ||
83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
84: where htau.time_building_block_id= :p_det_bb_id
85: and htau.time_building_block_ovn = :p_det_bb_ovn
86: and tbb.time_building_block_id = htau.time_building_block_id
87: and tbb.object_version_number = htau.time_building_block_ovn

Line 103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

99: and htau.time_attribute_id = hta.time_attribute_id
100: and hta.attribute_category = :p_context';
101: else
102: l_query := l_query ||
103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
104: where htau.time_building_block_id= :p_det_bb_id
105: and htau.time_building_block_ovn = :p_det_bb_ovn
106: and htau.time_attribute_id = hta.time_attribute_id
107: and hta.bld_blk_info_type_id = bbit.bld_blk_info_type_id

Line 321: hxc_bld_blk_info_types bbit

317: ,'N' CHANGED
318: ,'N' PROCESS
319: from hxc_time_attributes a,
320: hxc_time_attribute_usages au,
321: hxc_bld_blk_info_types bbit
322: where au.time_building_block_id = p_building_block_id
323: and au.time_building_block_ovn = p_ovn
324: and au.time_attribute_id = a.time_attribute_id
325: and (not (a.attribute_category = 'SECURITY'))

Line 767: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%type;

763: l_select hxc_layout_comp_qualifiers.qualifier_attribute27%type;
764: l_time_building_block_id number;
765: l_time_building_block_ovn number;
766: l_query varchar2(32000);
767: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%type;
768: l_separator varchar2(10);
769: l_position number;
770: l_start_position number;
771:

Line 828: HXC_BLD_BLK_INFO_TYPES bbit

824: l_query:= 'select ta.'|| l_select;
825: l_query:= l_query || ' from
826: hxc_time_attributes ta,
827: hxc_time_attribute_usages tau,
828: HXC_BLD_BLK_INFO_TYPES bbit
829: where tau.time_building_block_id = :l_time_building_block_id and tau.time_building_block_ovn = :l_time_building_block_ovn
830: and tau.time_attribute_id = ta.time_attribute_id
831: and bbit.bld_blk_info_type_id = ta.bld_blk_info_type_id
832: and bbit.bld_blk_info_type = :l_bld_blk_info_type';