APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_MAPPING_COMPONENTS

Line 3659: FROM hxc_mapping_components hmc, hxc_time_attributes hta

3655: p_att_ovn NUMBER
3656: )
3657: IS
3658: SELECT hmc.field_name
3659: FROM hxc_mapping_components hmc, hxc_time_attributes hta
3660: WHERE hta.time_attribute_id = p_attribute_id
3661: AND hta.object_version_number = p_att_ovn
3662: AND hta.bld_blk_info_type_id = hmc.bld_blk_info_type_id
3663: AND hmc.SEGMENT = UPPER (p_attribute);

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 4666: from hxc_mapping_components mc

4662: /*
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

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 5440: FROM hxc_mapping_components mc

5436: p_prompt IN OUT NOCOPY VARCHAR2)
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

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);