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_RESTORE dependencies on HXT_SUM_HOURS_WORKED_F

Line 546: hxt_sum_hours_worked_f_ar sum

542: IS SELECT DISTINCT
543: sum.id,
544: sum.tim_id
545: FROM hxc_temp_timecard_chunks temp,
546: hxt_sum_hours_worked_f_ar sum
547: WHERE temp.id = sum.time_building_block_id
548: AND temp.thread_id = p_thread_id;
549:
550:

Line 1685: INSERT INTO hxt_sum_hours_worked_f

1681: VALUES ( sum_id_tab(i),
1682: tim_id_tab(i),
1683: p_thread_id);
1684:
1685: INSERT INTO hxt_sum_hours_worked_f
1686: ( state_name, county_name, city_name, zip_code, ffv_cost_center_id,
1687: ffv_labor_account_id, tas_id, location_id, sht_id, hrw_comment,
1688: ffv_rate_code_id, rate_multiple, hourly_rate, amount, fcl_tax_rule_code,
1689: separate_check_flag, seqno, created_by, creation_date, last_updated_by,

Line 1714: FROM hxt_sum_hours_worked_f_ar sum,

1710: attribute22, attribute23, attribute24, attribute25, attribute26, attribute27,
1711: attribute28, attribute29, attribute30, object_version_number, time_building_block_id,
1712: time_building_block_ovn, id, line_status, tim_id, date_worked, assignment_id,
1713: hours, time_in, time_out, element_type_id, fcl_earn_reason_code
1714: FROM hxt_sum_hours_worked_f_ar sum,
1715: hxc_archive_temp temp
1716: WHERE temp.detail_id = sum.id
1717: AND temp.thread_id = p_thread_id;
1718:

Line 1723: DELETE FROM hxt_sum_hours_worked_f_ar

1719:
1720: l_hxt_sum_count := l_hxt_sum_count + SQL%ROWCOUNT;
1721:
1722: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1723: DELETE FROM hxt_sum_hours_worked_f_ar
1724: WHERE id = sum_id_tab(i);
1725:
1726: l_hxt_sum_del_count := l_hxt_sum_del_count + SQL%ROWCOUNT;
1727: