eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_LATEST_DETAILS

Line 1064: update hxc_latest_details

1060: open get_app_period(l_bb_id, l_bb_ovn, p_app_bb_id);
1061: fetch get_app_period into l_other_app_id;
1062:
1063: IF get_app_period%notfound then
1064: update hxc_latest_details
1065: set last_update_date = sysdate
1066: where time_building_block_id = l_bb_id
1067: and object_version_number = l_bb_ovn;
1068:

Line 2324: from hxc_latest_details

2320:
2321: -- Bug 8685110
2322: -- this is to check if the timecard ever had any details attached to it
2323: select count(*) into l_tc_details
2324: from hxc_latest_details
2325: where resource_id = p_resource_id
2326: and trunc(start_time) >= trunc(p_start_time)
2327: and trunc(stop_time) <= trunc(p_stop_time);
2328:

Line 2503: ,hxc_latest_details latest

2499: SELECT count(*)
2500: INTO l_active_details
2501: FROM hxc_ap_detail_links apdetail
2502: ,hxc_time_building_blocks detail
2503: ,hxc_latest_details latest
2504: WHERE apdetail.application_period_id = l_app_id
2505: AND apdetail.time_building_block_id = latest.time_building_block_id
2506: AND latest.time_building_block_id = detail.time_building_block_id
2507: AND latest.object_version_number = detail.object_version_number