DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_TRANSACTION_DETAILS

Line 77: FROM hxc_transaction_details htd,

73: CURSOR cur_chk_retr_history (p_curr_bb_id NUMBER ) IS
74: SELECT htd.time_building_block_id,
75: htd.time_building_block_ovn,
76: ht.transaction_process_id
77: FROM hxc_transaction_details htd,
78: hxc_transactions ht,
79: hxc_retrieval_processes hrp
80: WHERE htd.time_building_block_id = p_curr_bb_id
81: AND htd.transaction_id = ht.transaction_id

Line 1573: l_overall_status hxc_transaction_details.status%TYPE;

1569:
1570: l_last_day_index PLS_INTEGER;
1571: l_last_detail_index PLS_INTEGER;
1572:
1573: l_overall_status hxc_transaction_details.status%TYPE;
1574:
1575: BEGIN
1576: g_debug := hr_utility.debug_enabled;
1577: