APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_MAPPING_COMPONENTS

Line 3574: FROM hxc_mapping_components hmc, hxc_time_attributes hta

3570: p_att_ovn NUMBER
3571: )
3572: IS
3573: SELECT hmc.field_name
3574: FROM hxc_mapping_components hmc, hxc_time_attributes hta
3575: WHERE hta.time_attribute_id = p_attribute_id
3576: AND hta.object_version_number = p_att_ovn
3577: AND hta.bld_blk_info_type_id = hmc.bld_blk_info_type_id
3578: AND hmc.SEGMENT = UPPER (p_attribute);

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

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

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

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

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