APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTE_USAGES_AR

Line 485: hxc_time_attribute_usages_ar ar

481: time_attribute_usage_id,
482: time_attribute_id,
483: ROWIDTOCHAR(ar.ROWID)
484: FROM hxc_temp_timecard_chunks temp,
485: hxc_time_attribute_usages_ar ar
486: WHERE ar.time_building_block_id = temp.id
487: AND thread_id = p_thread_id ;
488:
489: CURSOR get_tbb_rowid (p_scope VARCHAR2)

Line 1573: hxc_time_attribute_usages_ar bkuptau

1569: bkuptau.DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1570: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1571: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1572: FROM hxc_archive_temp temp,
1573: hxc_time_attribute_usages_ar bkuptau
1574: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1575: AND thread_id = p_thread_id
1576: AND bkuptau.data_set_id = p_data_set_id;
1577:

Line 1582: DELETE FROM hxc_time_attribute_usages_ar

1578:
1579: l_tau_count := l_tau_count + SQL%ROWCOUNT;
1580:
1581: FORALL i IN usage_rowid_tab.FIRST..usage_rowid_tab.LAST
1582: DELETE FROM hxc_time_attribute_usages_ar
1583: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i))
1584: AND data_set_id = p_data_set_id;
1585:
1586: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;