APPS.HXC_RESTORE dependencies on HXC_LATEST_DETAILS

Line 508: hxc_latest_details det

504: id,
505: ref_ovn,
506: ROWIDTOCHAR(temp.ROWID)
507: FROM hxc_temp_timecard_chunks temp,
508: hxc_latest_details det
509: WHERE temp.scope = 'DETAIL'
510: AND temp.id = det.time_building_block_id
511: AND thread_id = p_thread_id ;
512:

Line 1871: INSERT INTO hxc_latest_details

1867: END LOOP;
1868: CLOSE get_max_ovn;
1869:
1870:
1871: INSERT INTO hxc_latest_details
1872: (resource_id,
1873: time_building_block_id,
1874: object_version_number,
1875: approval_status,

Line 1911: UPDATE hxc_latest_details

1907: bgtab LIMIT 1000;
1908: EXIT WHEN orgtab.COUNT =0;
1909:
1910: FORALL i IN orgtab.FIRST..orgtab.LAST
1911: UPDATE hxc_latest_details
1912: SET org_id = orgtab(i),
1913: business_group_id = bgtab(i)
1914: WHERE time_building_block_id = hldidtab(i)
1915: AND object_version_number = hldovntab(i);