APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_TIMECARD_SUMMARY

Line 139: select /*+ index_ffs (t HXC_TIMECARD_SUMMARY_PK ) parallel (t,4)*/ count(timecard_id)

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;
141:
142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

Line 140: into p_ts_count from hxc_timecard_summary t;

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;
141:
142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');

Line 155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_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;
159: