DBA Data[Home] [Help]

APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_TRANSACTION_DETAILS

Line 1748: hxc_transaction_details htd,

1744: det.detail_bb_id,
1745: det.detail_bb_ovn
1746: FROM hxc_rpt_tc_details_all det,
1747: hxc_rpt_tc_resource_temp gt,
1748: hxc_transaction_details htd,
1749: hxc_transactions ht
1750: WHERE gt.tc_start_time = det.tc_start_time
1751: AND gt.tc_stop_time = det.tc_stop_time
1752: AND gt.resource_id = det.resource_id

Line 1834: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,

1830:
1831: BEGIN
1832:
1833: -- Public Procedure update_transaction_ids
1834: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1835: -- and HXC_TRANSACTIONS to pick up all the transactions and
1836: -- transaction_details for a successful deposit.
1837: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1838: -- If p_record_save is set to Y, we need to give pseudo transaction_ids