APPS.HXC_RESTORE dependencies on HXC_AP_DETAIL_LINKS_AR

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

1296: INSERT INTO hxc_ap_detail_links
1297: (application_period_id,
1298: time_building_block_id,
1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1301: application_period_id, time_building_block_id, time_building_block_ovn
1302: FROM hxc_temp_timecard_chunks temp,
1303: hxc_ap_detail_links_ar adlbkup
1304: WHERE temp.id = adlbkup.time_building_block_id

Line 1303: hxc_ap_detail_links_ar adlbkup

1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1301: application_period_id, time_building_block_id, time_building_block_ovn
1302: FROM hxc_temp_timecard_chunks temp,
1303: hxc_ap_detail_links_ar adlbkup
1304: WHERE temp.id = adlbkup.time_building_block_id
1305: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1306: AND temp.scope = ('DETAIL')
1307: AND thread_id = p_thread_id ;

Line 1312: DELETE FROM hxc_ap_detail_links_ar

1308:
1309: l_adl_count := SQL%ROWCOUNT;
1310:
1311:
1312: DELETE FROM hxc_ap_detail_links_ar
1313: WHERE (time_building_block_id,time_building_block_ovn)
1314: IN ( SELECT id,
1315: ref_ovn
1316: FROM hxc_temp_timecard_chunks