APPS.HXC_TIMECARD_UTILITIES dependencies on HR_GENERAL

Line 478: AND DATE_TO = hr_general.end_of_time

474: STOP_TIME,
475: APPROVAL_STATUS
476: FROM hxc_time_building_blocks
477: WHERE SCOPE = 'TIMECARD'
478: AND DATE_TO = hr_general.end_of_time
479: AND RESOURCE_ID = p_resource_id
480: AND RESOURCE_TYPE = p_resource_type
481: AND STOP_TIME >= p_first_start_date
482: AND START_TIME <= p_last_end_date

Line 1258: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)

1254: )
1255: IS
1256: SELECT pas.ASSIGNMENT_ID,
1257: pas.EFFECTIVE_START_DATE,
1258: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1259: FROM PER_ALL_ASSIGNMENTS_F pas,
1260: per_assignment_status_types typ
1261: WHERE pas.PERSON_ID = p_resource_id
1262: AND pas.ASSIGNMENT_TYPE in ('E','C')

Line 1378: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)

1374: )
1375: IS
1376: SELECT pas.ASSIGNMENT_ID,
1377: pas.EFFECTIVE_START_DATE,
1378: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1379: FROM PER_ALL_ASSIGNMENTS_F pas,
1380: per_assignment_status_types typ
1381: WHERE pas.PERSON_ID = p_resource_id
1382: AND pas.ASSIGNMENT_TYPE = 'E'

Line 1506: g_past_date_limit := hr_general.START_OF_TIME;

1502: IF l_num_past_days IS NOT NULL
1503: THEN
1504: g_past_date_limit := SYSDATE - TO_NUMBER(l_num_past_days);
1505: ELSE
1506: g_past_date_limit := hr_general.START_OF_TIME;
1507: END IF;
1508:
1509: IF l_num_future_days IS NOT NULL
1510: THEN

Line 1513: g_future_date_limit := hr_general.END_OF_TIME;

1509: IF l_num_future_days IS NOT NULL
1510: THEN
1511: g_future_date_limit := SYSDATE + TO_NUMBER(l_num_future_days);
1512: ELSE
1513: g_future_date_limit := hr_general.END_OF_TIME;
1514: END IF;
1515: g_initialized := 'Y';
1516:
1517: IF g_debug THEN

Line 1815: --and date_to = hr_general.end_of_time;

1811: FROM hxc_time_building_blocks
1812: where time_building_block_id = p_timecard_id
1813: and resource_id = p_resource_id
1814: and scope = 'TIMECARD';
1815: --and date_to = hr_general.end_of_time;
1816:
1817:
1818: CURSOR crs_day_info (
1819: p_resource_id IN NUMBER,

Line 1948: --and day.date_to = hr_general.end_of_time

1944: and day.object_version_number = detail.parent_building_block_ovn
1945: and day.scope = 'DAY'
1946: and detail.resource_id = l_resource_id
1947: and detail.scope = 'DETAIL'
1948: --and day.date_to = hr_general.end_of_time
1949: --and detail.date_to = hr_general.end_of_time
1950: and day.parent_building_block_id = timecard_id
1951: and day.parent_building_block_ovn = timecard_ovn
1952: and day.resource_id = l_resource_id)

Line 1949: --and detail.date_to = hr_general.end_of_time

1945: and day.scope = 'DAY'
1946: and detail.resource_id = l_resource_id
1947: and detail.scope = 'DETAIL'
1948: --and day.date_to = hr_general.end_of_time
1949: --and detail.date_to = hr_general.end_of_time
1950: and day.parent_building_block_id = timecard_id
1951: and day.parent_building_block_ovn = timecard_ovn
1952: and day.resource_id = l_resource_id)
1953: UNION

Line 2003: where -- day.date_to = hr_general.end_of_time

1999: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2000: and (au.time_building_block_id,au.time_building_block_ovn) in
2001: (select day.time_building_block_id,day.object_version_number
2002: from hxc_time_building_blocks day
2003: where -- day.date_to = hr_general.end_of_time
2004: day.scope = 'DAY'
2005: and day.parent_building_block_id = timecard_id
2006: and day.parent_building_block_ovn = timecard_ovn
2007: and day.resource_id = l_resource_id)

Line 2058: where --htbb.date_to = hr_general.end_of_time

2054: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2055: and (au.time_building_block_id,au.time_building_block_ovn) in
2056: (select time_building_block_id,object_version_number
2057: from hxc_time_building_blocks htbb
2058: where --htbb.date_to = hr_general.end_of_time
2059: htbb.scope = 'TIMECARD'
2060: and htbb.time_building_block_id = timecard_id
2061: and htbb.object_version_number = timecard_ovn
2062: and htbb.resource_id = l_resource_id)