APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTES

Line 1221: FROM hxc_time_attributes

1217: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1218:
1219: DELETE FROM hxc_archive_temp
1220: WHERE EXISTS ( SELECT 1
1221: FROM hxc_time_attributes
1222: WHERE time_attribute_id = master_id )
1223: AND thread_id = p_thread_id ;
1224:
1225: INSERT INTO hxc_time_attributes

Line 1225: INSERT INTO hxc_time_attributes

1221: FROM hxc_time_attributes
1222: WHERE time_attribute_id = master_id )
1223: AND thread_id = p_thread_id ;
1224:
1225: INSERT INTO hxc_time_attributes
1226: (ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,
1227: ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,
1228: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1229: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,

Line 1239: FROM hxc_time_attributes_ar bkupta

1235: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1236: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,
1237: ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1238: ATTRIBUTE14,null,DATA_SET_ID
1239: FROM hxc_time_attributes_ar bkupta
1240: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1241: master_id
1242: FROM hxc_archive_temp temp
1243: WHERE thread_id = p_thread_id )

Line 1250: FROM hxc_time_attributes_ar bkupta

1246:
1247: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1248:
1249: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1250: FROM hxc_time_attributes_ar bkupta
1251: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1252: master_id
1253: FROM hxc_archive_temp temp
1254: WHERE thread_id = p_thread_id )