eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMECARD_SEARCH_PKG dependencies on HR_GENERAL

Line 74: || ' AND htbb_detail.date_to = hr_general.end_of_time'

70: || 'hxc_time_attribute_usages htau, '
71: || 'hxc_time_attributes hta'
72: || ' WHERE htbb_detail.resource_id = '
73: || ':p_resource_id'
74: || ' AND htbb_detail.date_to = hr_general.end_of_time'
75: || ' AND htau.time_building_block_id = htbb_detail.time_building_block_id'
76: || ' AND htau.time_building_block_ovn = htbb_detail.object_version_number'
77: || ' AND htau.time_attribute_id = hta.time_attribute_id'
78: || ' AND hta.attribute_category = '

Line 459: -- Bug 2486271; Changed hr_general.decode_lookup to hr_bis.bis_decode_lookup.

455: begin
456:
457: l_status_code := get_timecard_status_code(bb_id,bb_ovn);
458:
459: -- Bug 2486271; Changed hr_general.decode_lookup to hr_bis.bis_decode_lookup.
460: select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
461: from dual;
462: -- select hr_bis.bis_decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
463: -- from dual;

Line 460: select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning

456:
457: l_status_code := get_timecard_status_code(bb_id,bb_ovn);
458:
459: -- Bug 2486271; Changed hr_general.decode_lookup to hr_bis.bis_decode_lookup.
460: select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
461: from dual;
462: -- select hr_bis.bis_decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
463: -- from dual;
464:

Line 508: -- AND details.date_to = hr_general.end_of_time

504: details.object_version_number
505: AND tau.time_attribute_id = ta.time_attribute_id
506: AND ta.attribute_category = 'REASON'
507: AND details.scope = 'DETAIL'
508: -- AND details.date_to = hr_general.end_of_time
509: AND details.parent_building_block_id =
510: days.time_building_block_id
511: -- AND details.parent_building_block_ovn =
512: -- days.object_version_number

Line 514: -- AND days.date_to = hr_general.end_of_time

510: days.time_building_block_id
511: -- AND details.parent_building_block_ovn =
512: -- days.object_version_number
513: AND days.scope = 'DAY'
514: -- AND days.date_to = hr_general.end_of_time
515: AND days.parent_building_block_id = p_timecard_id
516: AND days.parent_building_block_ovn = p_timecard_ovn);
517:
518: l_cla_status varchar2(3);

Line 670: and hap.date_to = hr_general.end_of_time

666: hxc_time_building_blocks hap
667: where
668: hap.scope = 'APPLICATION_PERIOD'
669: and hap.type = 'RANGE'
670: and hap.date_to = hr_general.end_of_time
671: and hap.resource_type = 'PERSON'
672: and hap.start_time <= p_tc_stop_time
673: and hap.stop_time >= p_tc_start_time
674: and hap.resource_id = p_resource_id

Line 687: and days.date_to = hr_general.end_of_time

683: ,hxc_time_building_blocks days
684: where days.parent_building_block_id = p_timecard_id
685: and days.parent_building_block_ovn = p_timecard_ovn
686: and days.scope = 'DAY'
687: and days.date_to = hr_general.end_of_time
688: and details.parent_building_block_id = days.time_building_block_id
689: and details.parent_building_block_ovn = days.object_version_number
690: and details.date_to = hr_general.end_of_time
691: and details.scope = 'DETAIL';

Line 690: and details.date_to = hr_general.end_of_time

686: and days.scope = 'DAY'
687: and days.date_to = hr_general.end_of_time
688: and details.parent_building_block_id = days.time_building_block_id
689: and details.parent_building_block_ovn = days.object_version_number
690: and details.date_to = hr_general.end_of_time
691: and details.scope = 'DETAIL';
692:
693: cursor csr_get_latest_day
694: (p_timecard_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

Line 702: and date_to = hr_general.end_of_time;

698: from hxc_time_building_blocks
699: where parent_building_block_id = p_timecard_id
700: and parent_building_block_ovn = p_timecard_ovn
701: and scope = 'DAY'
702: and date_to = hr_general.end_of_time;
703:
704: l_app_periods app_period_table;
705:
706: l_count number;

Line 1179: || ' AND htbb_day.date_to = hr_general.end_of_time'

1175:
1176: l_sql_where := l_sql_where
1177: || ' AND htbb_day.parent_building_block_id = hrt.timecard_id'
1178: || ' AND htbb_day.parent_building_block_ovn = hrt.timecard_ovn'
1179: || ' AND htbb_day.date_to = hr_general.end_of_time'
1180: || ' AND htbb_detail.parent_building_block_id = htbb_day.time_building_block_id'
1181: || ' AND htbb_detail.parent_building_block_ovn = htbb_day.object_version_number'
1182: || ' AND htbb_detail.date_to = hr_general.end_of_time';
1183:

Line 1182: || ' AND htbb_detail.date_to = hr_general.end_of_time';

1178: || ' AND htbb_day.parent_building_block_ovn = hrt.timecard_ovn'
1179: || ' AND htbb_day.date_to = hr_general.end_of_time'
1180: || ' AND htbb_detail.parent_building_block_id = htbb_day.time_building_block_id'
1181: || ' AND htbb_detail.parent_building_block_ovn = htbb_day.object_version_number'
1182: || ' AND htbb_detail.date_to = hr_general.end_of_time';
1183:
1184:
1185: l_detail_join_flag := TRUE;
1186: END IF;

Line 1260: || ' AND htbb_day.date_to = hr_general.end_of_time'

1256:
1257: l_sql_where := l_sql_where
1258: || ' AND htbb_day.parent_building_block_id = hrt.timecard_id'
1259: || ' AND htbb_day.parent_building_block_ovn = hrt.timecard_ovn'
1260: || ' AND htbb_day.date_to = hr_general.end_of_time'
1261: || ' AND htbb_detail.parent_building_block_id = htbb_day.time_building_block_id'
1262: || ' AND htbb_detail.parent_building_block_ovn = htbb_day.object_version_number'
1263: || ' AND htbb_detail.date_to = hr_general.end_of_time';
1264:

Line 1263: || ' AND htbb_detail.date_to = hr_general.end_of_time';

1259: || ' AND htbb_day.parent_building_block_ovn = hrt.timecard_ovn'
1260: || ' AND htbb_day.date_to = hr_general.end_of_time'
1261: || ' AND htbb_detail.parent_building_block_id = htbb_day.time_building_block_id'
1262: || ' AND htbb_detail.parent_building_block_ovn = htbb_day.object_version_number'
1263: || ' AND htbb_detail.date_to = hr_general.end_of_time';
1264:
1265:
1266: l_detail_join_flag := TRUE;
1267: END IF;