eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_LATEST_DETAILS

Line 154: hxc_latest_details latest,

150: latest.object_version_number,
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)

Line 373: SELECT /*+ LEADING (latest HXC_LATEST_DETAILS_N1)

369: -- Populate TEMP table with absences data that has to be created
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,

Line 394: FROM hxc_latest_details latest,

390: to_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