APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 104: hxc_bld_blk_info_types bbit

100: , tcc.ref_time_category_id
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'

Line 158: hxc_bld_blk_info_types bbit

154: , av.attribute28
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

Line 1654: l_first_context hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1650: l_is_null VARCHAR2(20);
1651:
1652: l_comps_t l_comps_tab;
1653:
1654: l_first_context hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1655:
1656: BEGIN -- alternate_name_string
1657:
1658: g_debug := hr_utility.debug_enabled;

Line 2803: hxc_bld_blk_info_types bbit

2799: bbit.bld_blk_info_type context
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

Line 3365: , hxc_bld_blk_info_types bbit

3361: , tccs.sql_string
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'

Line 5614: hxc_bld_blk_info_types bbit

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:
5618:

Line 5659: hxc_bld_blk_info_types bbit

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
5663: AND hatc.mapping_component_id = hmc.mapping_component_id