APPS.HXC_UPGRADE_PKG dependencies on HXT_DET_HOURS_WORKED_F

Line 1454: INSERT INTO hxt_det_hours_worked_f_ar

1450: DELETE FROM hxt_sum_hours_worked_f
1451: WHERE id = sumidtab(i);
1452:
1453:
1454: INSERT INTO hxt_det_hours_worked_f_ar
1455: ( data_set_id, state_name, county_name, city_name, zip_code, id, parent_id, line_status,
1456: tim_id, date_worked, assignment_id, hours, time_in, time_out, element_type_id,
1457: fcl_earn_reason_code, ffv_cost_center_id, ffv_labor_account_id, tas_id, location_id,
1458: sht_id, hrw_comment, ffv_rate_code_id, rate_multiple, hourly_rate, amount,

Line 1473: hxt_det_hours_worked_f det

1469: last_update_date, last_update_login, actual_time_in, actual_time_out, job_id, earn_pol_id,
1470: effective_start_date, effective_end_date, pbl_line_id, retro_pbl_line_id, project_id,
1471: prev_wage_code, pa_status, pay_status, retro_batch_id, object_version_number
1472: FROM hxc_archive_temp temp,
1473: hxt_det_hours_worked_f det
1474: WHERE temp.detail_id = det.parent_id ;
1475:
1476:
1477: FORALL i IN sumidtab.FIRST..sumidtab.LAST

Line 1478: DELETE FROM hxt_det_hours_worked_f

1474: WHERE temp.detail_id = det.parent_id ;
1475:
1476:
1477: FORALL i IN sumidtab.FIRST..sumidtab.LAST
1478: DELETE FROM hxt_det_hours_worked_f
1479: WHERE parent_id = sumidtab(i);
1480:
1481: FORALL i IN timidtab.FIRST..timidtab.LAST
1482: UPDATE hxt_timecards_f