[Home] [Help]
98: -- Added to pick up the summary id from HXT table.
99: CURSOR get_tim_id
100: IS SELECT DISTINCT sum.id
101: FROM hxc_time_building_blocks_ar ar,
102: hxt_sum_hours_worked_f sum
103: WHERE ar.time_building_block_id = sum.time_building_block_id
104: AND ar.object_version_number = sum.time_building_block_ovn
105: AND ar.scope = 'DETAIL';
106:
954: p_end NUMBER)
955: IS SELECT DISTINCT sum.id,
956: sum.tim_id,
957: ar.data_set_id
958: FROM hxt_sum_hours_worked_f sum,
959: hxc_time_building_blocks_ar ar
960: WHERE sum.id BETWEEN p_start
961: AND p_end
962: AND sum.time_building_block_id = ar.time_building_block_id
1411: VALUES (sumidtab(i),timidtab(i),dsidtab(i));
1412:
1413:
1414:
1415: INSERT INTO hxt_sum_hours_worked_f_ar
1416: ( state_name, county_name, city_name, zip_code, ffv_cost_center_id,
1417: ffv_labor_account_id, tas_id, location_id, sht_id, hrw_comment,
1418: ffv_rate_code_id, rate_multiple, hourly_rate, amount, fcl_tax_rule_code,
1419: separate_check_flag, seqno, created_by, creation_date, last_updated_by,
1440: attribute22, attribute23, attribute24, attribute25, attribute26, attribute27,
1441: attribute28, attribute29, attribute30, object_version_number, time_building_block_id,
1442: time_building_block_ovn, id, line_status, tim_id, date_worked, assignment_id,
1443: hours, time_in, time_out, element_type_id, fcl_earn_reason_code ,thread_id
1444: FROM hxt_sum_hours_worked_f sum,
1445: hxc_archive_temp temp
1446: WHERE temp.detail_id = sum.id ;
1447:
1448:
1446: WHERE temp.detail_id = sum.id ;
1447:
1448:
1449: FORALL i IN sumidtab.FIRST..sumidtab.LAST
1450: DELETE FROM hxt_sum_hours_worked_f
1451: WHERE id = sumidtab(i);
1452:
1453:
1454: INSERT INTO hxt_det_hours_worked_f_ar