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 135: AND days.date_to = hr_general.end_of_time

131: WHERE days.parent_building_block_id = p_timecard_id
132: AND days.parent_building_block_ovn = p_timecard_ovn
133: AND days.scope = 'DAY'
134: AND TRUNC(days.start_time) BETWEEN TRUNC(p_start_time) AND TRUNC(p_stop_time)
135: AND days.date_to = hr_general.end_of_time
136: AND details.scope = 'DETAIL'
137: AND details.parent_building_block_id = days.time_building_block_id
138: AND details.parent_building_block_ovn = days.object_version_number
139: AND details.date_to = hr_general.end_of_time;

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

135: AND days.date_to = hr_general.end_of_time
136: AND details.scope = 'DETAIL'
137: AND details.parent_building_block_id = days.time_building_block_id
138: AND details.parent_building_block_ovn = days.object_version_number
139: AND details.date_to = hr_general.end_of_time;
140:
141: l_cursor_blocks c_detail_blocks%ROWTYPE;
142:
143: l_detail_blocks block_table;

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

427: AND days.parent_building_block_id = p_timecard_id
428: AND details.parent_building_block_id = days.time_building_block_id
429: AND details.time_building_block_id = apdetail.time_building_block_id
430: AND details.object_version_number = apdetail.time_building_block_ovn
431: AND details.date_to <> hr_general.end_of_time
432: and not exists(
433: select 1
434: from hxc_time_building_blocks details2
435: where details2.time_building_block_id = details.time_building_block_id

Line 436: and details2.date_to = hr_general.end_of_time

432: and not exists(
433: select 1
434: from hxc_time_building_blocks details2
435: where details2.time_building_block_id = details.time_building_block_id
436: and details2.date_to = hr_general.end_of_time
437: );
438:
439: l_count number := 0;
440:

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

579: ,hxc_time_building_blocks details
580: WHERE apdetail.application_period_id = p_app_period
581: AND apdetail.time_building_block_id = details.time_building_block_id
582: AND apdetail.time_building_block_ovn = details.object_version_number
583: AND details.date_to <> hr_general.end_of_time;
584:
585:
586: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
587: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;

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

1731: ,hxc_time_building_blocks blocks
1732: WHERE details.application_period_id = p_app_id
1733: AND details.time_building_block_id = blocks.time_building_block_id
1734: AND details.time_building_block_ovn = blocks.object_version_number
1735: AND blocks.date_to = hr_general.end_of_time;
1736:
1737: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1738: BEGIN
1739: OPEN c_details(p_app_id);

Line 2462: AND day1.date_to = hr_general.end_of_time

2458: hxc_time_building_blocks timecard
2459: WHERE day1.resource_id = p_resource_id
2460: AND day1.scope = 'DAY'
2461: AND day1.start_time BETWEEN p_period_start_date AND p_period_end_date
2462: AND day1.date_to = hr_general.end_of_time
2463: AND timecard.time_building_block_id = day1.parent_building_block_id
2464: AND timecard.object_version_number = day1.parent_building_block_ovn
2465: AND timecard.scope = 'TIMECARD'
2466: AND timecard.date_to = hr_general.end_of_time

Line 2466: AND timecard.date_to = hr_general.end_of_time

2462: AND day1.date_to = hr_general.end_of_time
2463: AND timecard.time_building_block_id = day1.parent_building_block_id
2464: AND timecard.object_version_number = day1.parent_building_block_ovn
2465: AND timecard.scope = 'TIMECARD'
2466: AND timecard.date_to = hr_general.end_of_time
2467: ORDER BY day1.start_time desc;
2468: --
2469: l_approval_style_id number;
2470: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.get_approval_style_id';

Line 3312: AND day.date_to = hr_general.end_of_time

3308: WHERE TRUNC(day.start_time) = p_day
3309: AND day.scope = 'DAY'
3310: AND day.approval_status = 'SUBMITTED'
3311: AND day.resource_id = p_resource_id
3312: AND day.date_to = hr_general.end_of_time
3313: AND day.parent_building_block_id = tc.time_building_block_id
3314: AND day.parent_building_block_ovn = tc.object_version_number
3315: AND tc.scope = 'TIMECARD'
3316: AND tc.date_to = hr_general.end_of_time;

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

3312: AND day.date_to = hr_general.end_of_time
3313: AND day.parent_building_block_id = tc.time_building_block_id
3314: AND day.parent_building_block_ovn = tc.object_version_number
3315: AND tc.scope = 'TIMECARD'
3316: AND tc.date_to = hr_general.end_of_time;
3317:
3318: l_submitted VARCHAR2(1);
3319: BEGIN
3320: OPEN c_submitted(p_day, p_resource_id);