DBA Data[Home] [Help]

APPS.HXC_RESTORE dependencies on HXT_DET_HOURS_WORKED_F_AR

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: