APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_TRANSACTION_DETAILS

Line 115: select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)

111: select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (t,4)*/ count(time_attribute_id)
112: into p_ta_count from hxc_time_attributes t;
113:
114: -- Transaction Details
115: select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)
116: into p_td_count from hxc_transaction_details t;
117:
118: -- Transactions
119: select /*+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)*/ count(transaction_id)

Line 116: into p_td_count from hxc_transaction_details t;

112: into p_ta_count from hxc_time_attributes t;
113:
114: -- Transaction Details
115: select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)
116: into p_td_count from hxc_transaction_details t;
117:
118: -- Transactions
119: select /*+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)*/ count(transaction_id)
120: into p_trans_count from hxc_transactions t;

Line 192: into p_td_ar_count from hxc_transaction_details_ar t;

188: into p_ta_ar_count from hxc_time_attributes_ar t;
189:
190: -- Transaction Details
191: select /*+ index_ffs (t HXC_TRANS_DETAILS_AR_PK ) parallel (t,4)*/ count(transaction_detail_id)
192: into p_td_ar_count from hxc_transaction_details_ar t;
193:
194: -- Transactions
195: select /*+ index_ffs (t HXC_TRANSACTIONS_AR_PK ) parallel (t,4)*/ count(transaction_id)
196: into p_trans_ar_count from hxc_transactions_ar t;