APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_TRANSACTION_DETAILS

Line 57: FROM hxc_transaction_details txd, hxc_transactions tx

53: AND dyovn.date_to <> hr_general.end_of_time)
54: AND tbb.date_to <> hr_general.end_of_time
55: AND EXISTS (
56: SELECT 'x'
57: FROM hxc_transaction_details txd, hxc_transactions tx
58: WHERE tx.transaction_process_id = -1
59: AND tx.TYPE = 'RETRIEVAL'
60: AND tx.status = 'SUCCESS'
61: AND tx.transaction_id = txd.transaction_id

Line 70: FROM hxc_transaction_details txd1

66: tbb.object_version_number);
67:
68: /*AND NOT EXISTS
69: (select 'x'
70: FROM hxc_transaction_details txd1
71: ,hxc_transactions tx1
72: WHERE tx1.transaction_process_id = -1
73: AND tx1.type = 'RETRIEVAL'
74: AND tx1.status = 'SUCCESS'