APPS.HXC_ARCHIVE dependencies on HXC_TC_AP_LINKS_AR

Line 683: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar

679: -- * Pick up all records from hxc_time_building_blocks for these combinations
680: -- and insert into hxc_time_building_blocks_ar
681: -- * For the timecard records in hxc_temp_timecard_chunks, pick up all records
682: -- from hxc_tc_ap_links, and insert into itself with application_period scope.
683: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
684: -- table.
685: -- * Delete these records from hxc_tc_ap_links table.
686: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
687: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.

Line 911: INSERT INTO hxc_tc_ap_links_ar

907: AND temp.scope IN ('TIMECARD')
908: AND thread_id = p_thread_id ;
909:
910:
911: INSERT INTO hxc_tc_ap_links_ar
912: ( timecard_id,
913: application_period_id)
914: SELECT timecard_id,
915: application_period_id