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 HR_GENERAL

Line 41: and petf.effective_end_date = hr_general.end_of_time;

37: pay_element_types_f petf
38: where
39: upper(petf.element_name) = hl.lookup_code
40: and hl.lookup_type = p_lookup_type
41: and petf.effective_end_date = hr_general.end_of_time;
42:
43: CURSOR csr_element_details(p_timecard_id NUMBER,
44: p_timecard_ovn NUMBER,
45: p_element_segment VARCHAR2,

Line 94: and tbb_det.date_to = hr_general.end_of_time

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'
94: and tbb_det.date_to = hr_general.end_of_time
95: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
96: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
97: and tbb_day.parent_building_block_id = p_timecard_id
98: and tbb_day.parent_building_block_ovn = p_timecard_ovn

Line 236: and petf.effective_end_date = hr_general.end_of_time;

232: pay_element_types_f petf
233: where
234: upper(petf.element_name) = hl.lookup_code
235: and hl.lookup_type = p_lookup_type
236: and petf.effective_end_date = hr_general.end_of_time;
237:
238: CURSOR csr_element_details(p_period_start_time DATE,
239: p_period_stop_time DATE,
240: p_resource_id NUMBER,

Line 291: and tbb_day.date_to = hr_general.end_of_time

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'
291: and tbb_day.date_to = hr_general.end_of_time
292: and tbb_det.date_to = hr_general.end_of_time
293: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
294: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
295: and tbb_day.start_time >= p_period_start_time

Line 292: and tbb_det.date_to = hr_general.end_of_time

288: hxc_time_attributes ta_det
289: WHERE tbb_det.scope = 'DETAIL'
290: and tbb_day.scope = 'DAY'
291: and tbb_day.date_to = hr_general.end_of_time
292: and tbb_det.date_to = hr_general.end_of_time
293: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
294: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
295: and tbb_day.start_time >= p_period_start_time
296: and tbb_day.stop_time <= p_period_stop_time

Line 444: and tbb_det.date_to = hr_general.end_of_time

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
445: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
446: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
447: and tbb_day.parent_building_block_ovn = tbb_tim.object_version_number
448: and tbb_day.parent_building_block_id = tbb_tim.time_building_block_id

Line 494: and tbb_det.date_to = hr_general.end_of_time

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
493: and tbb_day.parent_building_block_id = tbb_tim.time_building_block_id
494: and tbb_det.date_to = hr_general.end_of_time
495: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
496: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
497: and tbb_day.parent_building_block_id = p_timecard_id
498: and tbb_day.parent_building_block_ovn = p_timecard_ovn;