[Home] [Help]
1749: det.detail_bb_id,
1750: det.detail_bb_ovn
1751: FROM hxc_rpt_tc_details_all det,
1752: hxc_rpt_tc_resource_temp gt,
1753: hxc_transaction_details htd,
1754: hxc_transactions ht
1755: WHERE gt.tc_start_time = det.tc_start_time
1756: AND gt.tc_stop_time = det.tc_stop_time
1757: AND gt.resource_id = det.resource_id
1862:
1863: BEGIN
1864:
1865: -- Public Procedure update_transaction_ids
1866: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1867: -- and HXC_TRANSACTIONS to pick up all the transactions and
1868: -- transaction_details for a successful deposit.
1869: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1870: -- If p_record_save is set to Y, we need to give pseudo transaction_ids