DBA Data[Home] [Help]

APPS.HXC_ARCHIVE dependencies on HXC_TC_AP_LINKS_AR

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

636: -- * Pick up all records from hxc_time_building_blocks for these combinations
637: -- and insert into hxc_time_building_blocks_ar
638: -- * For the timecard records in hxc_temp_timecard_chunks, pick up all records
639: -- from hxc_tc_ap_links, and insert into itself with application_period scope.
640: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
641: -- table.
642: -- * Delete these records from hxc_tc_ap_links table.
643: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
644: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.

Line 868: INSERT INTO hxc_tc_ap_links_ar

864: AND temp.scope IN ('TIMECARD')
865: AND thread_id = p_thread_id ;
866:
867:
868: INSERT INTO hxc_tc_ap_links_ar
869: ( timecard_id,
870: application_period_id)
871: SELECT timecard_id,
872: application_period_id