DBA Data[Home] [Help]

APPS.HXC_RESTORE dependencies on HXT_SUM_HOURS_WORKED_F_AR

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