DBA Data[Home] [Help]

APPS.HXC_UPGRADE_PKG dependencies on HXC_ARCHIVE_TEMP

Line 1409: INSERT INTO hxc_archive_temp

1405: END IF;
1406:
1407:
1408: FORALL i IN sumidtab.FIRST..sumidtab.LAST
1409: INSERT INTO hxc_archive_temp
1410: (detail_id,master_id,thread_id)
1411: VALUES (sumidtab(i),timidtab(i),dsidtab(i));
1412:
1413:

Line 1445: hxc_archive_temp temp

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:
1449: FORALL i IN sumidtab.FIRST..sumidtab.LAST

Line 1472: FROM hxc_archive_temp temp,

1468: fcl_tax_rule_code, separate_check_flag, seqno, created_by, creation_date, last_updated_by,
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: