APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_LATEST_DETAILS

Line 135: select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)

131: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_PK ) parallel (t,4)*/ count(application_period_id)
132: into p_adl_count from hxc_ap_detail_links t;
133:
134: -- Latest Details
135: select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)
136: into p_ld_count from hxc_latest_details t;
137:
138: -- Timecard Summary
139: select /*+ index_ffs (t HXC_TIMECARD_SUMMARY_PK ) parallel (t,4)*/ count(timecard_id)

Line 136: into p_ld_count from hxc_latest_details t;

132: into p_adl_count from hxc_ap_detail_links t;
133:
134: -- Latest Details
135: select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)
136: into p_ld_count from hxc_latest_details t;
137:
138: -- Timecard Summary
139: select /*+ index_ffs (t HXC_TIMECARD_SUMMARY_PK ) parallel (t,4)*/ count(timecard_id)
140: into p_ts_count from hxc_timecard_summary t;

Line 154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);

150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:
157:
158: END core_table_count_snapshot;