APPS.HXC_RESTORE dependencies on HXC_AP_DETAIL_LINKS_AR

Line 1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */

1795: INSERT INTO hxc_ap_detail_links
1796: (application_period_id,
1797: time_building_block_id,
1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1800: application_period_id, time_building_block_id, time_building_block_ovn
1801: FROM hxc_temp_timecard_chunks temp,
1802: hxc_ap_detail_links_ar adlbkup
1803: WHERE temp.id = adlbkup.time_building_block_id

Line 1802: hxc_ap_detail_links_ar adlbkup

1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1800: application_period_id, time_building_block_id, time_building_block_ovn
1801: FROM hxc_temp_timecard_chunks temp,
1802: hxc_ap_detail_links_ar adlbkup
1803: WHERE temp.id = adlbkup.time_building_block_id
1804: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1805: AND temp.scope = ('DETAIL')
1806: AND thread_id = p_thread_id ;

Line 1811: DELETE FROM hxc_ap_detail_links_ar

1807:
1808: l_adl_count := SQL%ROWCOUNT;
1809:
1810:
1811: DELETE FROM hxc_ap_detail_links_ar
1812: WHERE (time_building_block_id,time_building_block_ovn)
1813: IN ( SELECT id,
1814: ref_ovn
1815: FROM hxc_temp_timecard_chunks