APPS.HXC_RESTORE dependencies on HXC_DEP_TRANSACTIONS_AR

Line 447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar

443: AND thread_id = p_thread_id;
444:
445: -- Bug 8888813
446: -- Added the following cursors to pick up DEPOSIT type
447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar
448:
449: CURSOR get_old_transactions
450: IS SELECT /*+ LEADING(temp) */
451: transaction_detail_id,

Line 1479: FROM hxc_dep_transactions_ar bkuptxn,

1475: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1476: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1477: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1478: TRANSACTION_CODE
1479: FROM hxc_dep_transactions_ar bkuptxn,
1480: hxc_archive_temp temp
1481: WHERE transaction_id = master_id
1482: AND thread_id = p_thread_id
1483: AND transaction_id NOT IN ( SELECT transaction_id

Line 1493: FROM hxc_dep_transactions_ar bkuptxn

1489:
1490: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1491:
1492: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1493: FROM hxc_dep_transactions_ar bkuptxn
1494: WHERE transaction_id IN ( SELECT master_id
1495: FROM hxc_archive_temp temp
1496: WHERE thread_id = p_thread_id)
1497: AND data_set_id = p_data_set_id ;