DBA Data[Home] [Help]

APPS.HXC_UPGRADE_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 824: INDEX(hta hxc_time_attributes_pk) */

820: CURSOR c_get_details( p_start NUMBER,
821: p_end NUMBER)
822: IS SELECT /*+ LEADING(hld)
823: ORDERED
824: INDEX(hta hxc_time_attributes_pk) */
825: attribute1,
826: attribute2,
827: rowidtochar(hld.rowid)
828: FROM hxc_latest_details hld,

Line 830: hxc_time_attributes hta

826: attribute2,
827: rowidtochar(hld.rowid)
828: FROM hxc_latest_details hld,
829: hxc_time_attribute_usages hau,
830: hxc_time_attributes hta
831: WHERE hld.time_building_block_id BETWEEN p_start
832: AND p_end
833: AND hld.org_id IS NULL
834: AND hau.time_building_block_id = hld.time_building_block_id