68: CURSOR cur_chk_retr_history (p_curr_bb_id NUMBER ) IS
69: SELECT htd.time_building_block_id,
70: htd.time_building_block_ovn,
71: ht.transaction_process_id
72: FROM hxc_transaction_details htd,
73: hxc_transactions ht,
74: hxc_retrieval_processes hrp
75: WHERE htd.time_building_block_id = p_curr_bb_id
76: AND htd.transaction_id = ht.transaction_id
1418:
1419: l_last_day_index PLS_INTEGER;
1420: l_last_detail_index PLS_INTEGER;
1421:
1422: l_overall_status hxc_transaction_details.status%TYPE;
1423:
1424: BEGIN
1425: g_debug := hr_utility.debug_enabled;
1426: