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'
560: AND txnd.time_building_block_id = hld.time_building_block_id
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'
585: AND txnd1.time_building_block_id = hld.time_building_block_id
693:
694: CURSOR c_get_bee_retrieval
695: IS
696: SELECT retrieval_process_id
697: FROM hxc_retrieval_processes
698: WHERE name = 'BEE Retrieval Process';
699:
700: l_unretrieved_tc c_get_unretrieved_tcs%rowtype;
701: