APPS.HXC_MAPPING_UTILITIES dependencies on HR_GENERAL

Line 1561: IF ( tc.date_to = hr_general.end_of_time )

1557: -- only want to populate current bld blks whose ovn is not 1
1558:
1559: l_index := tc.bb_id;
1560:
1561: IF ( tc.date_to = hr_general.end_of_time )
1562: THEN
1563: t_bld_blks(l_index) := tc;
1564: ELSE
1565: t_del_bld_blks(l_index) := tc;

Line 1648: IF ( r_old_del_bld_blks.date_to <> hr_general.end_of_time )

1644: -- if it was deleted or we did not find one then do nothing
1645:
1646: IF ( csr_get_bld_blk%FOUND )
1647: THEN
1648: IF ( r_old_del_bld_blks.date_to <> hr_general.end_of_time )
1649: THEN
1650: if g_debug then
1651: hr_utility.set_location('Processing '||l_proc, 110);
1652: end if;

Line 2482: and detbb.date_to = hr_general.end_of_time

2478: and tbb.object_version_number = detbb.object_version_number
2479: and detbb.parent_building_block_id = daybb.time_building_block_id
2480: and detbb.parent_building_block_ovn = daybb.object_version_number
2481: and time_status.timecard_id = daybb.parent_building_block_id
2482: and detbb.date_to = hr_general.end_of_time
2483: and time_status.approval_status IN '||l_status_list||' ) ';
2484:
2485: l_query := l_query ||l_status;
2486:

Line 2974: AND tbb.date_to = hr_general.end_of_time

2970: WHERE tbb1.time_building_block_id = tbb.time_building_block_id )
2971: AND tau.time_building_block_id = tbb.time_building_block_id
2972: AND tau.time_building_block_ovn = tbb.object_version_number
2973: AND tau.time_attribute_id = ta.time_attribute_id
2974: AND tbb.date_to = hr_general.end_of_time
2975: And ta.bld_blk_info_type_id = :l_bld_blk_info_type_id';
2976:
2977:
2978: if g_debug then