APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 3379: FROM hxc_time_attributes a,

3375: a.attribute22, a.attribute23, a.attribute24, a.attribute25,
3376: a.attribute26, a.attribute27, a.attribute28, a.attribute29,
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

Line 3389: FROM hxc_time_attributes

3385: AND NOT (a.attribute_category = 'TEMPLATES')
3386: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
3387: AND a.object_version_number =
3388: (SELECT MAX (object_version_number)
3389: FROM hxc_time_attributes
3390: WHERE time_attribute_id = a.time_attribute_id);
3391:
3392: l_tbb_index NUMBER;
3393: l_att_index NUMBER;

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 5346: ,hxc_time_attributes hta

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
5349: AND hta.time_attribute_id = p_block_id
5350: AND hta.object_version_number = p_blk_ovn