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_TIMECARD_HOURS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 88: FROM hxc_time_building_blocks tbb_day,

84: tbb_det.start_time,
85: tbb_det.stop_time,
86: tbb_det.type,
87: tbb_det.scope
88: FROM hxc_time_building_blocks tbb_day,
89: hxc_time_building_blocks tbb_det,
90: hxc_time_attribute_usages tau_det,
91: hxc_time_attributes ta_det
92: WHERE tbb_det.scope = 'DETAIL'

Line 89: hxc_time_building_blocks tbb_det,

85: tbb_det.stop_time,
86: tbb_det.type,
87: tbb_det.scope
88: FROM hxc_time_building_blocks tbb_day,
89: hxc_time_building_blocks tbb_det,
90: hxc_time_attribute_usages tau_det,
91: hxc_time_attributes ta_det
92: WHERE tbb_det.scope = 'DETAIL'
93: and tbb_day.scope = 'DAY'

Line 285: FROM hxc_time_building_blocks tbb_day,

281: tbb_det.start_time,
282: tbb_det.stop_time,
283: tbb_det.type,
284: tbb_det.scope
285: FROM hxc_time_building_blocks tbb_day,
286: hxc_time_building_blocks tbb_det,
287: hxc_time_attribute_usages tau_det,
288: hxc_time_attributes ta_det
289: WHERE tbb_det.scope = 'DETAIL'

Line 286: hxc_time_building_blocks tbb_det,

282: tbb_det.stop_time,
283: tbb_det.type,
284: tbb_det.scope
285: FROM hxc_time_building_blocks tbb_day,
286: hxc_time_building_blocks tbb_det,
287: hxc_time_attribute_usages tau_det,
288: hxc_time_attributes ta_det
289: WHERE tbb_det.scope = 'DETAIL'
290: and tbb_day.scope = 'DAY'

Line 438: FROM hxc_time_building_blocks tbb_day,

434: select
435: sum(decode(tbb_det.type,
436: 'MEASURE',nvl(tbb_det.measure,0),
437: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
438: FROM hxc_time_building_blocks tbb_day,
439: hxc_time_building_blocks tbb_det,
440: hxc_time_building_blocks tbb_tim
441: WHERE tbb_det.scope = 'DETAIL'
442: and tbb_day.scope = 'DAY'

Line 439: hxc_time_building_blocks tbb_det,

435: sum(decode(tbb_det.type,
436: 'MEASURE',nvl(tbb_det.measure,0),
437: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
438: FROM hxc_time_building_blocks tbb_day,
439: hxc_time_building_blocks tbb_det,
440: hxc_time_building_blocks tbb_tim
441: WHERE tbb_det.scope = 'DETAIL'
442: and tbb_day.scope = 'DAY'
443: and tbb_tim.scope = 'TIMECARD'

Line 440: hxc_time_building_blocks tbb_tim

436: 'MEASURE',nvl(tbb_det.measure,0),
437: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
438: FROM hxc_time_building_blocks tbb_day,
439: hxc_time_building_blocks tbb_det,
440: hxc_time_building_blocks tbb_tim
441: WHERE tbb_det.scope = 'DETAIL'
442: and tbb_day.scope = 'DAY'
443: and tbb_tim.scope = 'TIMECARD'
444: and tbb_det.date_to = hr_general.end_of_time

Line 486: FROM hxc_time_building_blocks tbb_day,

482: select
483: sum(decode(tbb_det.type,
484: 'MEASURE',nvl(tbb_det.measure,0),
485: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
486: FROM hxc_time_building_blocks tbb_day,
487: hxc_time_building_blocks tbb_det,
488: hxc_time_building_blocks tbb_tim
489: WHERE tbb_det.scope = 'DETAIL'
490: and tbb_day.scope = 'DAY'

Line 487: hxc_time_building_blocks tbb_det,

483: sum(decode(tbb_det.type,
484: 'MEASURE',nvl(tbb_det.measure,0),
485: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
486: FROM hxc_time_building_blocks tbb_day,
487: hxc_time_building_blocks tbb_det,
488: hxc_time_building_blocks tbb_tim
489: WHERE tbb_det.scope = 'DETAIL'
490: and tbb_day.scope = 'DAY'
491: and tbb_tim.scope = 'TIMECARD'

Line 488: hxc_time_building_blocks tbb_tim

484: 'MEASURE',nvl(tbb_det.measure,0),
485: 'RANGE', nvl(tbb_det.stop_time-tbb_det.start_time,0)*24)) into l_sum
486: FROM hxc_time_building_blocks tbb_day,
487: hxc_time_building_blocks tbb_det,
488: hxc_time_building_blocks tbb_tim
489: WHERE tbb_det.scope = 'DETAIL'
490: and tbb_day.scope = 'DAY'
491: and tbb_tim.scope = 'TIMECARD'
492: and tbb_day.parent_building_block_ovn = tbb_tim.object_version_number