DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HR_GENERAL

Line 39: and days.date_to = hr_general.end_of_time

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

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

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

Line 260: and date_to = hr_general.end_of_time

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