APPS.HXC_DATA_SET dependencies on HXC_TRANSACTIONS

Line 326: UPDATE hxc_transactions

322: FROM hxc_temp_timecard_chunks temp
323: WHERE temp.data_set_id = p_data_set_id
324: AND temp.scope in ('TIMECARD','DAY','DETAIL'));
325:
326: UPDATE hxc_transactions
327: SET data_set_id = p_data_set_id
328: WHERE transaction_id in
329: (SELECT distinct transaction_id
330: FROM hxc_transaction_details txnd,

Line 486: undo_define_table(p_table_name => 'HXC_TRANSACTIONS',

482: undo_define_table(p_table_name => 'HXC_TRANSACTION_DETAILS',
483: p_data_set_id => p_data_set_id,
484: p_chunk_size => l_chunk_size);
485:
486: undo_define_table(p_table_name => 'HXC_TRANSACTIONS',
487: p_data_set_id => p_data_set_id,
488: p_chunk_size => l_chunk_size);
489:
490: undo_define_table(p_table_name => 'HXC_TIMECARD_SUMMARY',

Line 555: hxc_transactions txn,

551: WHERE
552: NOT EXISTS
553: (SELECT 1
554: FROM hxc_transaction_details txnd,
555: hxc_transactions txn,
556: hxc_retrieval_processes rp
557: WHERE txn.type = 'RETRIEVAL'
558: AND txn.status = 'SUCCESS'
559: AND txnd.status = 'SUCCESS'

Line 580: hxc_transactions txn1,

576: )
577: OR ( det.date_to <> hr_general.end_of_time
578: AND EXISTS (SELECT 1
579: FROM hxc_transaction_details txnd1,
580: hxc_transactions txn1,
581: hxc_retrieval_processes rp1
582: WHERE txn1.type = 'RETRIEVAL'
583: AND txn1.status = 'SUCCESS'
584: AND txnd1.status = 'SUCCESS'