APPS.HXC_TIMEKEEPER_ERRORS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 29: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY

25: detail.scope scope,
26: nvl(detail.start_time,trunc(day.start_time)) start_time,
27: nvl(detail.stop_time,trunc(day.stop_time)) stop_time,
28: detail.measure measure
29: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
30: WHERE DAY.parent_building_block_id = p_timecard_id
31: AND DAY.parent_building_block_ovn = p_timecard_ovn
32: AND detail.date_to = hr_general.end_of_time
33: AND detail.SCOPE = 'DETAIL'

Line 45: FROM hxc_time_building_blocks

41: scope,
42: trunc(start_time),
43: trunc(stop_time),
44: measure
45: FROM hxc_time_building_blocks
46: WHERE time_building_block_id = p_timecard_id
47: and object_version_number = p_timecard_ovn
48: ORDER BY 4;
49:

Line 59: hxc_time_building_blocks bb

55: , bb.start_time
56: , bb.stop_time
57: , bb.resource_id
58: FROM
59: hxc_time_building_blocks bb
60: WHERE EXISTS ( select 'x'
61: from hxc_errors tke
62: where tke.time_building_block_id = bb.time_building_block_id
63: and tke.time_building_block_ovn = bb.object_version_number)

Line 211: from hxc_time_building_blocks

207:
208: cursor c_max_ovn
209: (p_tbb_id in number) is
210: select max(object_version_number)
211: from hxc_time_building_blocks
212: where time_building_block_id = p_tbb_id;
213:
214: cursor c_transaction_id
215: (p_tbb_id in number,

Line 235: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY

231: CURSOR c_detail_info (timecard_id IN NUMBER, timecard_ovn IN NUMBER)
232: IS
233: SELECT detail.time_building_block_id detail_id,
234: detail.object_version_number detail_ovn
235: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
236: WHERE DAY.parent_building_block_id = timecard_id
237: AND DAY.parent_building_block_ovn = timecard_ovn
238: AND detail.date_to = hr_general.end_of_time
239: AND detail.SCOPE = 'DETAIL'