DBA Data[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HXC_LATEST_DETAILS

Line 252: INSERT INTO hxc_latest_details (

248: --end if;
249:
250: -- insert row
251:
252: INSERT INTO hxc_latest_details (
253: resource_id,
254: time_building_block_id,
255: object_version_number,
256: approval_status,

Line 285: UPDATE hxc_latest_details

281: --end if;
282:
283: -- update row
284:
285: UPDATE hxc_latest_details
286: SET object_version_number = p_blocks(l_blk_ind).object_version_number,
287: approval_status = l_status,
288: application_set_id = p_blocks(l_blk_ind).application_set_id,
289: last_update_date = sysdate,

Line 299: INSERT INTO hxc_latest_details (

295: THEN
296:
297: -- nothing to update, insert
298:
299: INSERT INTO hxc_latest_details (
300: resource_id,
301: time_building_block_id,
302: object_version_number,
303: approval_status,