eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_TRANSACTIONS

Line 1632: hxc_transactions ht

1628: ht.transaction_id
1629: FROM hxc_ret_pay_latest_details latest,
1630: hxc_ret_pay_details det,
1631: hxc_transaction_details htd,
1632: hxc_transactions ht
1633: WHERE det.timecard_id = p_timecard_id
1634: AND det.batch_id = p_batch_id
1635: AND det.retro_batch_id = p_retro_batch_id
1636: AND det.time_building_block_id = latest.time_building_block_id

Line 1683: hxc_transactions ht

1679: ht.transaction_id
1680: FROM hxc_ret_pay_latest_details latest,
1681: hxc_ret_pay_details det,
1682: hxc_transaction_details htd,
1683: hxc_transactions ht
1684: WHERE det.timecard_id = p_timecard_id
1685: AND det.batch_id = p_batch_id
1686: AND det.retro_batch_id IS NULL
1687: AND det.time_building_block_id = latest.time_building_block_id

Line 1734: hxc_transactions ht

1730: ht.transaction_id
1731: FROM hxc_ret_pay_latest_details latest,
1732: hxc_ret_pay_details det,
1733: hxc_transaction_details htd,
1734: hxc_transactions ht
1735: WHERE det.timecard_id = p_timecard_id
1736: AND det.batch_id IS NULL
1737: AND det.retro_batch_id = p_retro_batch_id
1738: AND det.time_building_block_id = latest.time_building_block_id

Line 2659: hxc_transactions ht

2655: det.timecard_id,
2656: htd.transaction_detail_id
2657: FROM hxc_ret_pay_details det,
2658: hxc_transaction_details htd,
2659: hxc_transactions ht
2660: WHERE det.timecard_id = p_timecard_id
2661: AND det.time_building_block_id = htd.time_building_block_id
2662: AND det.object_version_number = htd.time_building_block_ovn
2663: AND htd.status = 'SUCCESS'