[Home] [Help]
968:
969: -- To pick up BEE Retrieval Process's Id.
970: CURSOR get_bee_process
971: IS SELECT retrieval_process_id
972: FROM hxc_retrieval_processes
973: WHERE name = 'BEE Retrieval Process';
974:
975: -- Bug 10008473
976: -- Added Order by so that timecards do not repeat themselves in the
1003: hxc_time_building_blocks day,
1004: hxc_time_building_blocks detail,
1005: hxc_latest_details hld,
1006: hxc_application_set_comps_v hasc,
1007: hxc_retrieval_processes hrp
1008: WHERE temp.master_id = day.parent_building_block_id
1009: AND temp.master_ovn = day.parent_building_block_ovn
1010: AND day.time_building_block_id = detail.parent_building_block_id
1011: AND day.object_version_number = detail.parent_building_block_ovn
1066: IS SELECT DISTINCT master_id,
1067: master_ovn,
1068: htr.name
1069: FROM hxc_upg_details_temp temp,
1070: hxc_retrieval_processes hrp,
1071: hxc_time_recipients htr
1072: WHERE TO_NUMBER(temp.detail_attribute1) = hrp.retrieval_process_id
1073: AND hrp.time_recipient_id = htr.time_recipient_id
1074: AND temp.thread_id = p_thread_id
1902: IS
1903:
1904: CURSOR get_process_id(p_process_name IN VARCHAR2)
1905: IS SELECT retrieval_process_id
1906: FROM hxc_retrieval_processes
1907: WHERE name = p_process_name;
1908:
1909: l_process_id NUMBER:= 0;
1910: