DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HR_GENERAL

Line 219: ) = hr_general.end_of_time

215: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
216:
217: IF (hxc_timecard_block_utils.date_value
218: (p_blocks (l_timecard_index).date_to
219: ) = hr_general.end_of_time
220: )
221: THEN
222: l_resubmit :=
223: hxc_timecard_approval.is_timecard_resubmitted

Line 512: ) = hr_general.end_of_time

508: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
509:
510: IF (hxc_timecard_block_utils.date_value
511: (p_blocks (l_timecard_index).date_to
512: ) = hr_general.end_of_time
513: )
514: THEN
515: l_resubmit :=
516: hxc_timecard_approval.is_timecard_resubmitted

Line 1526: AND tbb.date_to = hr_general.end_of_time

1522: WHERE tbb.SCOPE = v_scope
1523: AND tbb.resource_type = v_resource_type
1524: AND tbb.resource_id = v_resource_id
1525: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time
1526: AND tbb.date_to = hr_general.end_of_time
1527: AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
1528: AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
1529: AND parent_tbb.date_to = hr_general.end_of_time
1530: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope

Line 1529: AND parent_tbb.date_to = hr_general.end_of_time

1525: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time
1526: AND tbb.date_to = hr_general.end_of_time
1527: AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
1528: AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
1529: AND parent_tbb.date_to = hr_general.end_of_time
1530: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope
1531: GROUP BY tbb.time_building_block_id;
1532:
1533: l_building_block_count PLS_INTEGER;

Line 1954: AND date_to = hr_general.end_of_time

1950: IS
1951: SELECT time_building_block_id, MAX (object_version_number)
1952: FROM hxc_time_building_blocks
1953: WHERE SCOPE = hxc_timecard.c_timecard_scope
1954: AND date_to = hr_general.end_of_time
1955: CONNECT BY PRIOR parent_building_block_id = time_building_block_id
1956: AND PRIOR parent_building_block_ovn = object_version_number
1957: START WITH time_building_block_id = v_tc_id
1958: GROUP BY time_building_block_id

Line 2224: AND date_to = hr_general.end_of_time

2220: AND v_start_time >= start_time
2221: AND v_stop_time <= stop_time
2222: AND v_resource_id = resource_id
2223: AND v_resource_type = resource_type
2224: AND date_to = hr_general.end_of_time
2225: GROUP BY time_building_block_id;
2226: BEGIN
2227: g_debug :=hr_utility.debug_enabled;
2228: if g_debug then