APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_APP_PERIOD_SUMMARY_AR

Line 207: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)

203: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_AR_PK ) parallel (t,4)*/ count(application_period_id)
204: into p_adl_ar_count from hxc_ap_detail_links_ar t;
205:
206: -- Application Period Summary
207: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)
208: into p_aps_ar_count from hxc_app_period_summary_ar t;
209:
210:
211: -- Create the report

Line 208: into p_aps_ar_count from hxc_app_period_summary_ar t;

204: into p_adl_ar_count from hxc_ap_detail_links_ar t;
205:
206: -- Application Period Summary
207: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)
208: into p_aps_ar_count from hxc_app_period_summary_ar t;
209:
210:
211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

Line 222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);

218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:
224:
225: END bkup_table_count_snapshot;
226: