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

Line 149: AND days.date_to = hr_general.end_of_time

145: WHERE days.parent_building_block_id = p_timecard_id
146: AND days.parent_building_block_ovn = p_timecard_ovn
147: AND days.scope = 'DAY'
148: AND TRUNC(days.start_time) BETWEEN TRUNC(p_start_time) AND TRUNC(p_stop_time)
149: AND days.date_to = hr_general.end_of_time
150: AND details.scope = 'DETAIL'
151: AND details.parent_building_block_id = days.time_building_block_id
152: AND details.parent_building_block_ovn = days.object_version_number
153: AND details.date_to = hr_general.end_of_time;

Line 153: AND details.date_to = hr_general.end_of_time;

149: AND days.date_to = hr_general.end_of_time
150: AND details.scope = 'DETAIL'
151: AND details.parent_building_block_id = days.time_building_block_id
152: AND details.parent_building_block_ovn = days.object_version_number
153: AND details.date_to = hr_general.end_of_time;
154:
155: -- Bug 10164135
156: -- New cursor mimicking the above one, but with a new EXISTS clause
157: -- on Application set.

Line 198: AND days.date_to = hr_general.end_of_time

194: WHERE days.parent_building_block_id = p_timecard_id
195: AND days.parent_building_block_ovn = p_timecard_ovn
196: AND days.scope = 'DAY'
197: AND TRUNC(days.start_time) BETWEEN TRUNC(p_start_time) AND TRUNC(p_stop_time)
198: AND days.date_to = hr_general.end_of_time
199: AND details.scope = 'DETAIL'
200: AND details.parent_building_block_id = days.time_building_block_id
201: AND details.parent_building_block_ovn = days.object_version_number
202: AND details.date_to = hr_general.end_of_time

Line 202: AND details.date_to = hr_general.end_of_time

198: AND days.date_to = hr_general.end_of_time
199: AND details.scope = 'DETAIL'
200: AND details.parent_building_block_id = days.time_building_block_id
201: AND details.parent_building_block_ovn = days.object_version_number
202: AND details.date_to = hr_general.end_of_time
203: AND EXISTS ( SELECT 1
204: FROM hxc_application_set_comps_v hasc
205: WHERE hasc.application_set_id = details.application_set_id
206: AND hasc.time_recipient_id = p_time_recipient_id) ;

Line 583: AND details.date_to <> hr_general.end_of_time

579: AND days.parent_building_block_id = p_timecard_id
580: AND details.parent_building_block_id = days.time_building_block_id
581: AND details.time_building_block_id = apdetail.time_building_block_id
582: AND details.object_version_number = apdetail.time_building_block_ovn
583: AND details.date_to <> hr_general.end_of_time
584: and not exists(
585: select 1
586: from hxc_time_building_blocks details2
587: where details2.time_building_block_id = details.time_building_block_id

Line 588: and details2.date_to = hr_general.end_of_time

584: and not exists(
585: select 1
586: from hxc_time_building_blocks details2
587: where details2.time_building_block_id = details.time_building_block_id
588: and details2.date_to = hr_general.end_of_time
589: );
590:
591: l_count number := 0;
592:

Line 735: AND details.date_to <> hr_general.end_of_time;

731: ,hxc_time_building_blocks details
732: WHERE apdetail.application_period_id = p_app_period
733: AND apdetail.time_building_block_id = details.time_building_block_id
734: AND apdetail.time_building_block_ovn = details.object_version_number
735: AND details.date_to <> hr_general.end_of_time;
736:
737:
738: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
739: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;

Line 1914: AND blocks.date_to = hr_general.end_of_time;

1910: ,hxc_time_building_blocks blocks
1911: WHERE details.application_period_id = p_app_id
1912: AND details.time_building_block_id = blocks.time_building_block_id
1913: AND details.time_building_block_ovn = blocks.object_version_number
1914: AND blocks.date_to = hr_general.end_of_time;
1915:
1916: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1917: BEGIN
1918: OPEN c_details(p_app_id);

Line 2508: AND detail.date_to = hr_general.end_of_time;

2504: WHERE apdetail.application_period_id = l_app_id
2505: AND apdetail.time_building_block_id = latest.time_building_block_id
2506: AND latest.time_building_block_id = detail.time_building_block_id
2507: AND latest.object_version_number = detail.object_version_number
2508: AND detail.date_to = hr_general.end_of_time;
2509:
2510:
2511: hr_utility.trace('l_active_details = '||l_active_details);
2512:

Line 2810: AND day1.date_to = hr_general.end_of_time

2806: hxc_time_building_blocks timecard
2807: WHERE day1.resource_id = p_resource_id
2808: AND day1.scope = 'DAY'
2809: AND day1.start_time BETWEEN p_period_start_date AND p_period_end_date
2810: AND day1.date_to = hr_general.end_of_time
2811: AND timecard.time_building_block_id = day1.parent_building_block_id
2812: AND timecard.object_version_number = day1.parent_building_block_ovn
2813: AND timecard.scope = 'TIMECARD'
2814: AND timecard.date_to = hr_general.end_of_time

Line 2814: AND timecard.date_to = hr_general.end_of_time

2810: AND day1.date_to = hr_general.end_of_time
2811: AND timecard.time_building_block_id = day1.parent_building_block_id
2812: AND timecard.object_version_number = day1.parent_building_block_ovn
2813: AND timecard.scope = 'TIMECARD'
2814: AND timecard.date_to = hr_general.end_of_time
2815: ORDER BY day1.start_time desc;
2816: --
2817: l_approval_style_id number;
2818: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.get_approval_style_id';

Line 3943: AND day.date_to = hr_general.end_of_time

3939: WHERE TRUNC(day.start_time) = p_day
3940: AND day.scope = 'DAY'
3941: AND day.approval_status = 'SUBMITTED'
3942: AND day.resource_id = p_resource_id
3943: AND day.date_to = hr_general.end_of_time
3944: AND day.parent_building_block_id = tc.time_building_block_id
3945: AND day.parent_building_block_ovn = tc.object_version_number
3946: AND tc.scope = 'TIMECARD'
3947: AND tc.date_to = hr_general.end_of_time;

Line 3947: AND tc.date_to = hr_general.end_of_time;

3943: AND day.date_to = hr_general.end_of_time
3944: AND day.parent_building_block_id = tc.time_building_block_id
3945: AND day.parent_building_block_ovn = tc.object_version_number
3946: AND tc.scope = 'TIMECARD'
3947: AND tc.date_to = hr_general.end_of_time;
3948:
3949: l_submitted VARCHAR2(1);
3950: BEGIN
3951: OPEN c_submitted(p_day, p_resource_id);