APPS.HXC_ARCHIVE dependencies on HXC_AP_DETAIL_LINKS_AR

Line 733: -- details and insert into hxc_ap_detail_links_ar table.

729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.
737: -- * COMMIT and pick up the next chunk.

Line 1753: INSERT INTO hxc_ap_detail_links_ar

1749: END IF;
1750:
1751:
1752:
1753: INSERT INTO hxc_ap_detail_links_ar
1754: (application_period_id,
1755: time_building_block_id,
1756: time_building_block_ovn)
1757: SELECT application_period_id, time_building_block_id, time_building_block_ovn