APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 3439: hxc_bld_blk_info_types bbit

3435: a.attribute30, a.bld_blk_info_type_id,
3436: a.object_version_number, 'N' NEW, 'N' changed
3437: FROM hxc_time_attributes a,
3438: hxc_time_attribute_usages au,
3439: hxc_bld_blk_info_types bbit
3440: WHERE au.time_building_block_id = p_building_block_id
3441: AND au.time_building_block_ovn = p_bb_ovn
3442: AND au.time_attribute_id = a.time_attribute_id
3443: AND NOT (a.attribute_category = 'TEMPLATES')

Line 3470: hxc_bld_blk_info_types bbit

3466: a.attribute30, a.bld_blk_info_type_id,
3467: a.object_version_number, 'N' NEW, 'N' changed
3468: FROM hxc_time_attributes a,
3469: hxc_time_attribute_usages au,
3470: hxc_bld_blk_info_types bbit
3471: WHERE au.time_building_block_id = p_building_block_id
3472: AND au.time_building_block_ovn = p_bb_ovn
3473: AND au.time_attribute_id = a.time_attribute_id
3474: AND NOT (a.attribute_category = 'TEMPLATES')

Line 4658: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

4654: IS
4655: CURSOR csr_get_mapping_name(p_segment varchar2)
4656: IS
4657: SELECT hmc.field_name
4658: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
4659: WHERE hmc.segment = upper(p_segment)
4660: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
4661: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';
4662: /*

Line 4667: ,hxc_bld_blk_info_types bbit

4663: CURSOR csr_get_mapping_name(p_segment varchar2)
4664: IS
4665: select substr(fcu.form_left_prompt,1,30)
4666: from hxc_mapping_components mc
4667: ,hxc_bld_blk_info_types bbit
4668: ,fnd_descr_flex_col_usage_tl fcu
4669: where
4670: mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
4671: and fcu.application_column_name = mc.segment

Line 4818: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

4814: IS
4815: /* CURSOR csr_get_mapping_name(p_segment varchar2)
4816: IS
4817: SELECT hmc.field_name
4818: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
4819: WHERE hmc.segment = upper(p_segment)
4820: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
4821: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';*/
4822:

Line 5441: ,hxc_bld_blk_info_types bbit

5437: IS
5438: CURSOR C_GET_PROMPT_NAME(p_attribute VARCHAR2) IS
5439: SELECT substr(fcu.form_left_prompt,1,30) prompt
5440: FROM hxc_mapping_components mc
5441: ,hxc_bld_blk_info_types bbit
5442: ,fnd_descr_flex_col_usage_tl fcu
5443: ,hxc_time_attributes hta
5444: WHERE mc.SEGMENT= UPPER(p_attribute) --mapping_component_id = p_comp_id
5445: AND mc.bld_blk_info_type_id = hta.bld_blk_info_type_id

Line 5457: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

5453: AND fcu.language = userenv('LANG');
5454:
5455: CURSOR C_GET_PROMPT_BLK(p_attribute VARCHAR2) is
5456: SELECT hmc.field_name
5457: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
5458: WHERE hmc.segment = upper(p_attribute)
5459: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
5460: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';
5461: l_prompt_name varchar2(30);