APPS.HXC_ARCHIVE dependencies on HXC_DEP_TRANSACTIONS

Line 1427: FROM hxc_dep_transactions_ar

1423: CLOSE get_dup_trans;
1424:
1425: DELETE FROM hxc_archive_temp
1426: WHERE EXISTS ( SELECT 1
1427: FROM hxc_dep_transactions_ar
1428: WHERE transaction_id = master_id )
1429: AND thread_id = p_thread_id ;
1430:
1431: INSERT INTO hxc_dep_transactions_ar

Line 1431: INSERT INTO hxc_dep_transactions_ar

1427: FROM hxc_dep_transactions_ar
1428: WHERE transaction_id = master_id )
1429: AND thread_id = p_thread_id ;
1430:
1431: INSERT INTO hxc_dep_transactions_ar
1432: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1433: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1434: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1435: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1440: FROM hxc_dep_transactions bkuptxn,

1436: p_data_set_id,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1437: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1438: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1439: TRANSACTION_CODE
1440: FROM hxc_dep_transactions bkuptxn,
1441: hxc_archive_temp temp
1442: WHERE transaction_id = master_id
1443: AND thread_id = p_thread_id
1444: AND transaction_id NOT IN ( SELECT transaction_id

Line 1445: FROM hxc_dep_transactions_ar hxc

1441: hxc_archive_temp temp
1442: WHERE transaction_id = master_id
1443: AND thread_id = p_thread_id
1444: AND transaction_id NOT IN ( SELECT transaction_id
1445: FROM hxc_dep_transactions_ar hxc
1446: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1447: ;
1448:
1449: l_trans_count := l_trans_count + SQL%ROWCOUNT;

Line 1452: FROM hxc_dep_transactions bkuptxn

1448:
1449: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1450:
1451: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1452: FROM hxc_dep_transactions bkuptxn
1453: WHERE transaction_id IN ( SELECT master_id
1454: FROM hxc_archive_temp temp
1455: WHERE thread_id = p_thread_id) ;
1456: