APPS.HXC_RESTORE dependencies on HXT_DET_HOURS_WORKED_F

Line 1728: INSERT INTO hxt_det_hours_worked_f

1724: WHERE id = sum_id_tab(i);
1725:
1726: l_hxt_sum_del_count := l_hxt_sum_del_count + SQL%ROWCOUNT;
1727:
1728: INSERT INTO hxt_det_hours_worked_f
1729: ( state_name, county_name, city_name, zip_code, id, parent_id, line_status,
1730: tim_id, date_worked, assignment_id, hours, time_in, time_out, element_type_id,
1731: fcl_earn_reason_code, ffv_cost_center_id, ffv_labor_account_id, tas_id, location_id,
1732: sht_id, hrw_comment, ffv_rate_code_id, rate_multiple, hourly_rate, amount,

Line 1747: hxt_det_hours_worked_f_ar det

1743: last_update_date, last_update_login, actual_time_in, actual_time_out, job_id, earn_pol_id,
1744: effective_start_date, effective_end_date, pbl_line_id, retro_pbl_line_id, project_id,
1745: prev_wage_code, pa_status, pay_status, retro_batch_id, object_version_number
1746: FROM hxc_archive_temp temp,
1747: hxt_det_hours_worked_f_ar det
1748: WHERE temp.detail_id = det.parent_id
1749: AND temp.thread_id = p_thread_id;
1750:
1751: l_hxt_det_count := l_hxt_det_count + SQL%ROWCOUNT;

Line 1755: DELETE FROM hxt_det_hours_worked_f_ar

1751: l_hxt_det_count := l_hxt_det_count + SQL%ROWCOUNT;
1752:
1753:
1754: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1755: DELETE FROM hxt_det_hours_worked_f_ar
1756: WHERE parent_id = sum_id_tab(i);
1757:
1758: l_hxt_det_del_count := l_hxt_det_del_count + SQL%ROWCOUNT;
1759: