DBA Data[Home] [Help]

APPS.HXC_DATA_SET dependencies on HXC_RETRIEVAL_PROCESSES

Line 556: hxc_retrieval_processes rp

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

Line 581: hxc_retrieval_processes rp1

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

Line 697: FROM hxc_retrieval_processes

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: