DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_MAPPING_COMPONENTS

Line 105: , hxc_mapping_components mpc

101: , tcc.flex_value_set_id
102: , tcc.equal_to
103: FROM
104: hxc_bld_blk_info_types bbit
105: , hxc_mapping_components mpc
106: , hxc_time_category_comps tcc
107: WHERE tcc.time_category_id = p_time_category_id AND
108: tcc.type = 'MC'
109: AND

Line 159: , hxc_mapping_components mpc

155: , av.attribute29
156: , av.attribute30
157: FROM
158: hxc_bld_blk_info_types bbit
159: , hxc_mapping_components mpc
160: , hxc_alias_type_components atc
161: , hxc_alias_types hat
162: , hxc_alias_definitions ad
163: , hxc_alias_values av

Line 2804: , hxc_mapping_components mpc

2800: , bbit.bld_blk_info_type_id
2801: , mpc.segment
2802: FROM
2803: hxc_bld_blk_info_types bbit
2804: , hxc_mapping_components mpc
2805: WHERE
2806: mpc.mapping_component_id = p_mapping_component_id
2807: AND
2808: bbit.bld_blk_info_type_id = mpc.bld_blk_info_type_id;

Line 3366: , hxc_mapping_components mpc

3362: , tcc.last_update_date
3363: FROM
3364: hxc_time_category_comp_sql tccs
3365: , hxc_bld_blk_info_types bbit
3366: , hxc_mapping_components mpc
3367: , hxc_time_category_comps tcc
3368: WHERE tcc.time_category_id = p_time_category_id AND
3369: tcc.type <> 'MC'
3370: AND

Line 5613: FROM hxc_mapping_components hmc,

5609: CURSOR get_mapping_columns(p_comp_id IN NUMBER)
5610: IS SELECT hmc.bld_blk_info_type_id,
5611: hmc.segment,
5612: bbit.bld_blk_info_type
5613: FROM hxc_mapping_components hmc,
5614: hxc_bld_blk_info_types bbit
5615: WHERE hmc.mapping_component_id = p_comp_id
5616: AND hmc.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
5617:

Line 5658: hxc_mapping_components hmc,

5654: 'ATTRIBUTE30',hav.attribute30 ) value
5655: FROM hxc_alias_values hav,
5656: hxc_alias_definitions had,
5657: hxc_alias_type_components hatc,
5658: hxc_mapping_components hmc,
5659: hxc_bld_blk_info_types bbit
5660: WHERE alias_value_id = p_comp_id
5661: AND hav.alias_definition_id = had.alias_definition_id
5662: AND had.alias_type_id = hatc.alias_type_id