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 2398: --- and detbb.date_to = hr_general.end_of_time

2394: --- and tbb.object_version_number = detbb.object_version_number
2395: --- and detbb.parent_building_block_id = daybb.time_building_block_id
2396: --- and detbb.parent_building_block_ovn = daybb.object_version_number
2397: --- and time_status.timecard_id = daybb.parent_building_block_id
2398: --- and detbb.date_to = hr_general.end_of_time
2399: --- and time_status.approval_status IN ('WORKING','SUBMITTED','APPROVED') ) )
2400: ---
2401: ---
2402: --- Rows Row Source Operation

Line 2458: ---- and detbb.date_to = hr_general.end_of_time

2454: ---- and tbb.object_version_number = detbb.object_version_number
2455: ---- and detbb.parent_building_block_id = daybb.time_building_block_id
2456: ---- and detbb.parent_building_block_ovn = daybb.object_version_number
2457: ---- and time_status.timecard_id = daybb.parent_building_block_id
2458: ---- and detbb.date_to = hr_general.end_of_time
2459: ---- and time_status.approval_status IN ('WORKING','SUBMITTED','APPROVED') ) )
2460: ---- ;
2461:
2462:

Line 2714: and detbb.date_to = hr_general.end_of_time

2710: and tbb.object_version_number = detbb.object_version_number
2711: and detbb.parent_building_block_id = daybb.time_building_block_id
2712: and detbb.parent_building_block_ovn = daybb.object_version_number
2713: and time_status.timecard_id = daybb.parent_building_block_id
2714: and detbb.date_to = hr_general.end_of_time
2715: and time_status.approval_status IN '||l_status_list||' ) ';
2716:
2717: l_query := l_query ||l_status;
2718:

Line 3206: AND tbb.date_to = hr_general.end_of_time

3202: WHERE tbb1.time_building_block_id = tbb.time_building_block_id )
3203: AND tau.time_building_block_id = tbb.time_building_block_id
3204: AND tau.time_building_block_ovn = tbb.object_version_number
3205: AND tau.time_attribute_id = ta.time_attribute_id
3206: AND tbb.date_to = hr_general.end_of_time
3207: And ta.bld_blk_info_type_id = :l_bld_blk_info_type_id';
3208:
3209:
3210: if g_debug then