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_SUMMARY_PKG dependencies on HR_GENERAL

Line 40: and days.date_to = hr_general.end_of_time

36: where days.parent_building_block_id = p_id
37: and days.parent_building_block_ovn = p_ovn
38: and details.parent_building_block_id = days.time_building_block_id
39: and details.parent_building_block_ovn = days.object_version_number
40: and days.date_to = hr_general.end_of_time
41: and details.date_to = hr_general.end_of_time;
42:
43: CURSOR c_tc_resource_id(
44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

Line 41: and details.date_to = hr_general.end_of_time;

37: and days.parent_building_block_ovn = p_ovn
38: and details.parent_building_block_id = days.time_building_block_id
39: and details.parent_building_block_ovn = days.object_version_number
40: and days.date_to = hr_general.end_of_time
41: and details.date_to = hr_general.end_of_time;
42:
43: CURSOR c_tc_resource_id(
44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 261: and date_to = hr_general.end_of_time

257: ,creation_date
258: ,data_set_id
259: from hxc_time_building_blocks
260: where time_building_block_id = p_id
261: and date_to = hr_general.end_of_time
262: and scope = 'TIMECARD';
263:
264: cursor c_check_for_reasons is
265: select 'Y'

Line 705: AND ( det.date_to = hr_general.end_of_time

701: AND ht.transaction_id = htd.transaction_id
702: AND ht.type = 'RETRIEVAL'
703: AND ht.status = 'SUCCESS'
704: AND ht.transaction_process_id = p_process_id )
705: AND ( det.date_to = hr_general.end_of_time
706: OR ( det.date_to <> hr_general.end_of_time
707: AND EXISTS ( SELECT 1
708: FROM hxc_transactions ht,
709: hxc_transaction_details htd

Line 706: OR ( det.date_to <> hr_general.end_of_time

702: AND ht.type = 'RETRIEVAL'
703: AND ht.status = 'SUCCESS'
704: AND ht.transaction_process_id = p_process_id )
705: AND ( det.date_to = hr_general.end_of_time
706: OR ( det.date_to <> hr_general.end_of_time
707: AND EXISTS ( SELECT 1
708: FROM hxc_transactions ht,
709: hxc_transaction_details htd
710: WHERE htd.time_building_block_id = det.time_building_block_id