DBA Data[Home] [Help]

APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_LATEST_DETAILS

Line 459: UPDATE hxc_latest_details hld

455:
456: IF (C2.scope = 'DETAIL') THEN
457:
458: BEGIN
459: UPDATE hxc_latest_details hld
460: SET hld.application_set_id = l_application_set_id
461: WHERE hld.time_building_block_id =
462: C2.time_building_block_id AND
463: hld.object_version_number = C2.object_version_number;

Line 632: FROM hxc_latest_details hld

628: tbb.time_building_block_id) AND
629: tbb_day.time_building_block_id = tbb.parent_building_block_id AND
630: NOT EXISTS
631: (SELECT 'x'
632: FROM hxc_latest_details hld
633: WHERE hld.time_building_block_id = tbb.time_building_block_id) AND
634: tbb_day.object_Version_number =
635: (SELECT /*+ no_unnest */
636: MAX(dovn1.object_version_number)

Line 701: INSERT INTO hxc_latest_details

697:
698: IF (t_tbb_id.COUNT <> 0) THEN
699:
700: forall x in t_tbb_id.first .. t_tbb_id.last
701: INSERT INTO hxc_latest_details
702: (resource_id
703: ,time_building_block_id
704: ,object_version_number
705: ,approval_status