APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 3381: hxc_bld_blk_info_types bbit

3377: a.attribute30, a.bld_blk_info_type_id,
3378: a.object_version_number, 'N' NEW, 'N' changed
3379: FROM hxc_time_attributes a,
3380: hxc_time_attribute_usages au,
3381: hxc_bld_blk_info_types bbit
3382: WHERE au.time_building_block_id = p_building_block_id
3383: AND au.time_building_block_ovn = p_bb_ovn
3384: AND au.time_attribute_id = a.time_attribute_id
3385: AND NOT (a.attribute_category = 'TEMPLATES')

Line 4573: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

4569: IS
4570: CURSOR csr_get_mapping_name(p_segment varchar2)
4571: IS
4572: SELECT hmc.field_name
4573: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
4574: WHERE hmc.segment = upper(p_segment)
4575: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
4576: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';
4577: /*

Line 4582: ,hxc_bld_blk_info_types bbit

4578: CURSOR csr_get_mapping_name(p_segment varchar2)
4579: IS
4580: select substr(fcu.form_left_prompt,1,30)
4581: from hxc_mapping_components mc
4582: ,hxc_bld_blk_info_types bbit
4583: ,fnd_descr_flex_col_usage_tl fcu
4584: where
4585: mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
4586: and fcu.application_column_name = mc.segment

Line 4733: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

4729: IS
4730: /* CURSOR csr_get_mapping_name(p_segment varchar2)
4731: IS
4732: SELECT hmc.field_name
4733: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
4734: WHERE hmc.segment = upper(p_segment)
4735: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
4736: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';*/
4737:

Line 5344: ,hxc_bld_blk_info_types bbit

5340: IS
5341: CURSOR C_GET_PROMPT_NAME(p_attribute VARCHAR2) IS
5342: SELECT substr(fcu.form_left_prompt,1,30) prompt
5343: FROM hxc_mapping_components mc
5344: ,hxc_bld_blk_info_types bbit
5345: ,fnd_descr_flex_col_usage_tl fcu
5346: ,hxc_time_attributes hta
5347: WHERE mc.SEGMENT= UPPER(p_attribute) --mapping_component_id = p_comp_id
5348: AND mc.bld_blk_info_type_id = hta.bld_blk_info_type_id

Line 5360: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb

5356: AND fcu.language = userenv('LANG');
5357:
5358: CURSOR C_GET_PROMPT_BLK(p_attribute VARCHAR2) is
5359: SELECT hmc.field_name
5360: FROM hxc_mapping_components hmc, hxc_bld_blk_info_types hbb
5361: WHERE hmc.segment = upper(p_attribute)
5362: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
5363: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';
5364: l_prompt_name varchar2(30);