APPS.HXC_TIMEKEEPER dependencies on HR_GENERAL

Line 140: and date_to = hr_general.end_of_time;

136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));
137: update hxc_time_building_blocks
138: set date_to = sysdate
139: where time_building_block_id = app_period_tab(i)
140: and date_to = hr_general.end_of_time;
141:
142: delete from hxc_app_period_summary where APPLICATION_PERIOD_ID = app_period_tab(i);
143: end loop;
144: end if;

Line 1405: = hr_general.end_of_time)

1401: --
1402: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1403:
1404: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
1405: = hr_general.end_of_time)
1406: then
1407: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
1408: (p_blocks(l_timecard_index).time_building_block_id
1409: ,p_blocks(l_timecard_index).object_version_number

Line 2519: and tbb.date_to = hr_general.end_of_time;

2515: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
2516: select tbb.object_version_number
2517: from hxc_time_building_blocks tbb
2518: where tbb.time_building_block_id = p_timecard_id
2519: and tbb.date_to = hr_general.end_of_time;
2520: */
2521:
2522: CURSOR csr_chk_transfer (p_timecard_id hxc_time_building_blocks.time_building_block_id%type) IS
2523: SELECT 1