DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 3438: hxc_time_attribute_usages au,

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
3442: AND au.time_attribute_id = a.time_attribute_id

Line 3454: INDEX(AU HXC_TIME_ATTRIBUTE_USAGES_FK2)

3450:
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,

Line 3469: hxc_time_attribute_usages au,

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
3473: AND au.time_attribute_id = a.time_attribute_id