APPS.HXC_DATA_SET dependencies on HXC_RETRIEVAL_PROCESSES

Line 562: hxc_retrieval_processes rp

558: NOT EXISTS
559: (SELECT 1
560: FROM hxc_transaction_details txnd,
561: hxc_transactions txn,
562: hxc_retrieval_processes rp
563: WHERE txn.type = 'RETRIEVAL'
564: AND txn.status = 'SUCCESS'
565: AND txnd.status = 'SUCCESS'
566: AND txnd.time_building_block_id = hld.time_building_block_id

Line 587: hxc_retrieval_processes rp1

583: OR ( det.date_to <> hr_general.end_of_time
584: AND EXISTS (SELECT 1
585: FROM hxc_transaction_details txnd1,
586: hxc_transactions txn1,
587: hxc_retrieval_processes rp1
588: WHERE txn1.type = 'RETRIEVAL'
589: AND txn1.status = 'SUCCESS'
590: AND txnd1.status = 'SUCCESS'
591: AND txnd1.time_building_block_id = hld.time_building_block_id

Line 638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */

634: hxc_application_set_comps_v hasv,
635: per_all_people_f per
636: WHERE
637: NOT EXISTS
638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */
639: 1
640: FROM hxc_transaction_details txnd,
641: hxc_transactions txn,
642: hxc_retrieval_processes rp

Line 642: hxc_retrieval_processes rp

638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */
639: 1
640: FROM hxc_transaction_details txnd,
641: hxc_transactions txn,
642: hxc_retrieval_processes rp
643: WHERE txn.type = 'RETRIEVAL'
644: AND txn.status = 'SUCCESS'
645: AND txnd.status = 'SUCCESS'
646: AND txnd.time_building_block_id = hld.time_building_block_id

Line 667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */

663: AND det.parent_building_block_ovn = day.object_version_number
664: AND ( ( det.date_to = hr_general.end_of_time
665: )
666: OR ( det.date_to <> hr_general.end_of_time
667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */
668: 1
669: FROM hxc_transaction_details txnd1,
670: hxc_transactions txn1,
671: hxc_retrieval_processes rp1

Line 671: hxc_retrieval_processes rp1

667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */
668: 1
669: FROM hxc_transaction_details txnd1,
670: hxc_transactions txn1,
671: hxc_retrieval_processes rp1
672: WHERE txn1.type = 'RETRIEVAL'
673: AND txn1.status = 'SUCCESS'
674: AND txnd1.status = 'SUCCESS'
675: AND txnd1.time_building_block_id = hld.time_building_block_id

Line 786: FROM hxc_retrieval_processes

782:
783: CURSOR c_get_bee_retrieval
784: IS
785: SELECT retrieval_process_id
786: FROM hxc_retrieval_processes
787: WHERE name = 'BEE Retrieval Process';
788:
789: l_unretrieved_tc c_get_unretrieved_tcs%rowtype;
790: