[Home] [Help]
151: temp.absences_action,
152: detail.date_to
153: FROM hxc_abs_ret_temp temp,
154: hxc_latest_details latest,
155: hxc_time_building_blocks detail
156: WHERE temp.resource_id = c_resource_id
157: AND TRUNC (temp.day_start) >= TRUNC (c_tc_start)
158: AND TRUNC (temp.day_stop) <= TRUNC (c_tc_stop)
159: AND temp.retrieval_status = 'SUCCESS'
370: -- Absences which are new and not yet retrieved
371:
372: INSERT INTO hxc_abs_ret_temp (
373: SELECT /*+ LEADING (latest HXC_LATEST_DETAILS_N1)
374: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)
375: INDEX(htau HXC_TIME_ATTRIBUTE_USAGES_FK2)
376: INDEX(hta HXC_TIME_ATTRIBUTES_PK) */
377: detail.time_building_block_id, --time_building_block_id,
378: detail.object_version_number , --object_version_number,
391: SUBSTR(hta.attribute_category, 11)
392: ) , --element_type_id,
393: NULL --link_time_building_block_id
394: FROM hxc_latest_details latest,
395: hxc_time_building_blocks detail,
396: hxc_time_attribute_usages htau,
397: hxc_time_attributes hta,
398: hxc_absence_type_elements hate
399: WHERE latest.resource_id = g_resource_id
448: 'DELETE' , --absences_action,
449: absco.element_type_id , --element_type_id,
450: NULL --link_time_building_block_id
451: FROM hxc_abs_co_details absco,
452: hxc_time_building_blocks detail,
453: hxc_time_building_blocks DAY,
454: per_absence_attendances absatt
455: WHERE absco.resource_id = g_resource_id
456: AND TRUNC (absco.start_time) = TRUNC (g_tc_start)
449: absco.element_type_id , --element_type_id,
450: NULL --link_time_building_block_id
451: FROM hxc_abs_co_details absco,
452: hxc_time_building_blocks detail,
453: hxc_time_building_blocks DAY,
454: per_absence_attendances absatt
455: WHERE absco.resource_id = g_resource_id
456: AND TRUNC (absco.start_time) = TRUNC (g_tc_start)
457: AND TRUNC (absco.stop_time) = TRUNC (g_tc_stop)