DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 3437: FROM hxc_time_attributes a,

3433: a.attribute22, a.attribute23, a.attribute24, a.attribute25,
3434: a.attribute26, a.attribute27, a.attribute28, a.attribute29,
3435: a.attribute30, a.bld_blk_info_type_id,
3436: a.object_version_number, 'N' NEW, 'N' changed
3437: FROM hxc_time_attributes a,
3438: hxc_time_attribute_usages au,
3439: hxc_bld_blk_info_types bbit
3440: WHERE au.time_building_block_id = p_building_block_id
3441: AND au.time_building_block_ovn = p_bb_ovn

Line 3447: FROM hxc_time_attributes

3443: AND NOT (a.attribute_category = 'TEMPLATES')
3444: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
3445: AND a.object_version_number =
3446: (SELECT MAX (object_version_number)
3447: FROM hxc_time_attributes
3448: WHERE time_attribute_id = a.time_attribute_id);
3449: */
3450:
3451: CURSOR csr_get_det_attr (p_building_block_id NUMBER, p_bb_ovn NUMBER)

Line 3455: INDEX(A HXC_TIME_ATTRIBUTES_PK)

3451: CURSOR csr_get_det_attr (p_building_block_id NUMBER, p_bb_ovn NUMBER)
3452: IS
3453: SELECT /*+ LEADING(AU)
3454: INDEX(AU HXC_TIME_ATTRIBUTE_USAGES_FK2)
3455: INDEX(A HXC_TIME_ATTRIBUTES_PK)
3456: INDEX(BBIT HXC_BUILD_BLK_INFO_TYPES_PK) */
3457: a.time_attribute_id, au.time_building_block_id,
3458: bbit.bld_blk_info_type, a.attribute_category, a.attribute1,
3459: a.attribute2, a.attribute3, a.attribute4, a.attribute5,

Line 3468: FROM hxc_time_attributes a,

3464: a.attribute22, a.attribute23, a.attribute24, a.attribute25,
3465: a.attribute26, a.attribute27, a.attribute28, a.attribute29,
3466: a.attribute30, a.bld_blk_info_type_id,
3467: a.object_version_number, 'N' NEW, 'N' changed
3468: FROM hxc_time_attributes a,
3469: hxc_time_attribute_usages au,
3470: hxc_bld_blk_info_types bbit
3471: WHERE au.time_building_block_id = p_building_block_id
3472: AND au.time_building_block_ovn = p_bb_ovn

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

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
5445: AND mc.bld_blk_info_type_id = hta.bld_blk_info_type_id
5446: AND hta.time_attribute_id = p_block_id
5447: AND hta.object_version_number = p_blk_ovn