APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTES

Line 530: hxc_time_attributes hta

526: attribute1,
527: attribute2
528: FROM hxc_temp_timecard_chunks temp,
529: hxc_time_attribute_usages hau,
530: hxc_time_attributes hta
531: WHERE thread_id = p_thread_id
532: AND temp.id = hau.time_building_block_id
533: AND temp.ref_ovn = hau.time_building_block_ovn
534: AND hau.time_attribute_id = hta.time_attribute_id

Line 1590: FROM hxc_time_attributes

1586: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1587:
1588: DELETE FROM hxc_archive_temp
1589: WHERE EXISTS ( SELECT 1
1590: FROM hxc_time_attributes
1591: WHERE time_attribute_id = master_id )
1592: AND thread_id = p_thread_id ;
1593:
1594: INSERT INTO hxc_time_attributes

Line 1594: INSERT INTO hxc_time_attributes

1590: FROM hxc_time_attributes
1591: WHERE time_attribute_id = master_id )
1592: AND thread_id = p_thread_id ;
1593:
1594: INSERT INTO hxc_time_attributes
1595: (ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,
1596: ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,
1597: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1598: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,

Line 1608: FROM hxc_time_attributes_ar bkupta

1604: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1605: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,
1606: ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1607: ATTRIBUTE14,null,DATA_SET_ID
1608: FROM hxc_time_attributes_ar bkupta
1609: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1610: master_id
1611: FROM hxc_archive_temp temp
1612: WHERE thread_id = p_thread_id )

Line 1619: FROM hxc_time_attributes_ar bkupta

1615:
1616: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1617:
1618: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1619: FROM hxc_time_attributes_ar bkupta
1620: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1621: master_id
1622: FROM hxc_archive_temp temp
1623: WHERE thread_id = p_thread_id )