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

Line 548: hxt_sum_hours_worked_f sum

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

Line 1641: INSERT INTO hxt_sum_hours_worked_f_ar

1637: VALUES ( sum_id_tab(i),
1638: tim_id_tab(i),
1639: p_thread_id);
1640:
1641: INSERT INTO hxt_sum_hours_worked_f_ar
1642: ( state_name, county_name, city_name, zip_code, ffv_cost_center_id,
1643: ffv_labor_account_id, tas_id, location_id, sht_id, hrw_comment,
1644: ffv_rate_code_id, rate_multiple, hourly_rate, amount, fcl_tax_rule_code,
1645: separate_check_flag, seqno, created_by, creation_date, last_updated_by,

Line 1670: FROM hxt_sum_hours_worked_f sum,

1666: attribute22, attribute23, attribute24, attribute25, attribute26, attribute27,
1667: attribute28, attribute29, attribute30, object_version_number, time_building_block_id,
1668: time_building_block_ovn, id, line_status, tim_id, date_worked, assignment_id,
1669: hours, time_in, time_out, element_type_id, fcl_earn_reason_code ,p_data_set_id
1670: FROM hxt_sum_hours_worked_f sum,
1671: hxc_archive_temp temp
1672: WHERE temp.detail_id = sum.id
1673: AND temp.thread_id = p_thread_id;
1674:

Line 1679: DELETE FROM hxt_sum_hours_worked_f

1675:
1676: l_hxt_sum_count := l_hxt_sum_count + SQL%ROWCOUNT;
1677:
1678: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1679: DELETE FROM hxt_sum_hours_worked_f
1680: WHERE id = sum_id_tab(i);
1681:
1682: l_hxt_sum_del_count := l_hxt_sum_del_count + SQL%ROWCOUNT;
1683: