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_SELF_SERVICE_TIME_DEPOSIT dependencies on HR_GENERAL

Line 426: and date_to = hr_general.end_of_time

422: (select 'Y'
423: from hxc_time_building_blocks
424: where resource_id = p_r_id
425: and scope = 'APPLICATION_PERIOD'
426: and date_to = hr_general.end_of_time
427: and approval_status = 'REJECTED'
428: and p_date between start_time and stop_time
429: );
430:

Line 509: and date_to = hr_general.end_of_time

505: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE) is
506: select approval_status
507: from hxc_time_building_blocks
508: where time_building_block_id = p_time_building_block_id
509: and date_to = hr_general.end_of_time
510: and approval_status = 'WORKING';
511:
512: l_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
513:

Line 751: (g_timecard(p_block_number).date_to = hr_general.end_of_time)

747: --
748: -- Check end date first!
749: --
750: if (
751: (g_timecard(p_block_number).date_to = hr_general.end_of_time)
752: AND
753: (p_mode = 'UPDATE')
754: ) then
755:

Line 881: elsif ((g_timecard(p_block_number).date_to= hr_general.end_of_time)

877: close csr_old_block;
878:
879: end if;
880:
881: elsif ((g_timecard(p_block_number).date_to= hr_general.end_of_time)
882: AND
883: (p_mode = 'DELETE')) then
884: --
885: -- Here we are asking if a previously existing block

Line 909: if (g_timecard(p_block_number).date_to <> hr_general.end_of_time) then

905: else
906:
907: if(p_mode='DELETE') then
908:
909: if (g_timecard(p_block_number).date_to <> hr_general.end_of_time) then
910:
911: l_process := true;
912: l_not_just_approval_status := true;
913:

Line 1049: and tbb.date_to = hr_general.end_of_time

1045: ,hxc_time_attributes ta
1046: where ta.time_attribute_id = tau.time_attribute_id
1047: and tau.time_building_block_id = tbb.time_building_block_id
1048: and tau.time_building_block_ovn = tbb.object_version_number
1049: and tbb.date_to = hr_general.end_of_time
1050: and ta.attribute_category = 'TEMPLATES'
1051: and ta.attribute2 = 'PRIVATE'
1052: and tbb.scope = 'TIMECARD_TEMPLATE'
1053: and tbb.time_building_block_id <> p_time_building_block_id

Line 1067: and tbb.date_to = hr_general.end_of_time

1063: ,hxc_time_attributes ta
1064: where ta.time_attribute_id = tau.time_attribute_id
1065: and tau.time_building_block_id = tbb.time_building_block_id
1066: and tau.time_building_block_ovn = tbb.object_version_number
1067: and tbb.date_to = hr_general.end_of_time
1068: and ta.attribute_category = 'TEMPLATES'
1069: and ta.attribute2 = 'PUBLIC'
1070: and tbb.scope = 'TIMECARD_TEMPLATE'
1071: and tbb.time_building_block_id <> p_time_building_block_id

Line 1263: if(g_timecard(l_block).date_to = hr_general.end_of_time) then

1259: OR (g_timecard(l_block).scope = 'TIMECARD_TEMPLATE')) then
1260:
1261: l_day_start := l_day_start +1;
1262:
1263: if(g_timecard(l_block).date_to = hr_general.end_of_time) then
1264:
1265: if(hxc_deposit_checks.chk_timecard_deposit
1266: (g_timecard
1267: ,l_block

Line 1603: IF (g_timecard(l_block_index).date_to <> hr_general.end_of_time) THEN

1599: -- Slightly different for detail building blocks
1600: --
1601:
1602: IF g_attributes(p_attribute_number).attribute_category IS NOT NULL THEN
1603: IF (g_timecard(l_block_index).date_to <> hr_general.end_of_time) THEN
1604: --
1605: -- We want to make sure that attributes that go with deleted blocks
1606: -- are also sent to the validation procdures
1607: --

Line 4818: (g_timecard(l_block).date_to = hr_general.end_of_time)

4814: (g_timecard(l_block).scope='TIMECARD')
4815: AND
4816: (g_timecard(l_block).approval_status = 'SUBMITTED')
4817: AND
4818: (g_timecard(l_block).date_to = hr_general.end_of_time)
4819: ) then
4820:
4821: l_approval_timecard_id := g_timecard(l_block).time_building_block_id;
4822: l_approval_timecard_ovn := g_timecard(l_block).object_version_number;

Line 5102: and tbb_tim.date_to = hr_general.end_of_time

5098: tbb_tim.date_to tbb_tim_date_to,
5099: tbb_tim.comment_text tbb_tim_comment_text
5100: from hxc_time_building_blocks tbb_tim
5101: where tbb_tim.time_building_block_id = p_timecard_block
5102: and tbb_tim.date_to = hr_general.end_of_time
5103: and (tbb_tim.scope='TIMECARD' or tbb_tim.scope='TIMECARD_TEMPLATE');
5104:
5105: cursor get_day_building_blocks(p_timecard_block in number,p_timecard_ovn in number)
5106: is

Line 5126: and tbb_day.date_to = hr_general.end_of_time

5122: tbb_day.comment_text tbb_day_comment_text
5123: from hxc_time_building_blocks tbb_day
5124: where tbb_day.parent_building_block_ovn = p_timecard_ovn
5125: and tbb_day.parent_building_block_id = p_timecard_block
5126: and tbb_day.date_to = hr_general.end_of_time
5127: and tbb_day.scope='DAY';
5128:
5129: cursor get_detail_building_blocks(p_timecard_block in number,p_timecard_ovn in number)
5130: is

Line 5155: and tbb_det.date_to = hr_general.end_of_time

5151: where tbb_day.parent_building_block_ovn = p_timecard_ovn
5152: and tbb_day.parent_building_block_id = p_timecard_block
5153: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
5154: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
5155: and tbb_det.date_to = hr_general.end_of_time
5156: -- Why this condition is not met for a submitted timecard but is for saved timecards?
5157: -- and tbb_day.date_to = hr_general.end_of_time
5158: and tbb_det.scope='DETAIL';
5159:

Line 5157: -- and tbb_day.date_to = hr_general.end_of_time

5153: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
5154: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id
5155: and tbb_det.date_to = hr_general.end_of_time
5156: -- Why this condition is not met for a submitted timecard but is for saved timecards?
5157: -- and tbb_day.date_to = hr_general.end_of_time
5158: and tbb_det.scope='DETAIL';
5159:
5160: -- Bug Fix for 2388621
5161: -- Cursor to fetch the template details