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

Line 375: Select NVL(final_process_date, hr_general.end_of_time)

371: l_user_id NUMBER;
372:
373: /* Mikarthi Terminated CWK Enhancement */
374: Cursor c_cwk_terminate_date( p_person_id IN NUMBER, p_evaluation_date IN DATE) is
375: Select NVL(final_process_date, hr_general.end_of_time)
376: from per_periods_of_placement
377: where person_id = p_person_id
378: and date_start <= p_evaluation_date
379: order by date_start desc;

Line 1473: 'ALL_PEOPLE', hr_general.start_of_time

1469: hrr.rule_evaluation_order,
1470: hrr.start_date,
1471: hrr.end_date,
1472: decode(hrr.eligibility_criteria_type,
1473: 'ALL_PEOPLE', hr_general.start_of_time
1474: , pa.effective_start_date) elig_start_date,
1475: decode(hrr.eligibility_criteria_type,
1476: 'ALL_PEOPLE', hr_general.end_of_time
1477: , pa.effective_END_date) elig_end_date

Line 1476: 'ALL_PEOPLE', hr_general.end_of_time

1472: decode(hrr.eligibility_criteria_type,
1473: 'ALL_PEOPLE', hr_general.start_of_time
1474: , pa.effective_start_date) elig_start_date,
1475: decode(hrr.eligibility_criteria_type,
1476: 'ALL_PEOPLE', hr_general.end_of_time
1477: , pa.effective_END_date) elig_end_date
1478: FROM hxc_resource_rules hrr,
1479: per_all_assignments_f pa
1480: WHERE pa.person_id = p_resource_id

Line 2062: l_hierarchy_list(l_hier_count).start_date := hr_general.start_of_time;

2058: BEGIN
2059: FOR hier_rec IN c_personal_hierarchy(p_resource_id) LOOP
2060: l_hierarchy_list(l_hier_count).pref_hierarchy_id := hier_rec.pref_hierarchy_id;
2061: l_hierarchy_list(l_hier_count).rule_evaluation_order := hier_rec.rule_evaluation_order;
2062: l_hierarchy_list(l_hier_count).start_date := hr_general.start_of_time;
2063: l_hierarchy_list(l_hier_count).end_date := hr_general.end_of_time;
2064: l_hierarchy_list(l_hier_count).elig_start_date := hr_general.start_of_time;
2065: l_hierarchy_list(l_hier_count).elig_end_date := hr_general.end_of_time;
2066: l_hier_count := l_hier_count+1;

Line 2063: l_hierarchy_list(l_hier_count).end_date := hr_general.end_of_time;

2059: FOR hier_rec IN c_personal_hierarchy(p_resource_id) LOOP
2060: l_hierarchy_list(l_hier_count).pref_hierarchy_id := hier_rec.pref_hierarchy_id;
2061: l_hierarchy_list(l_hier_count).rule_evaluation_order := hier_rec.rule_evaluation_order;
2062: l_hierarchy_list(l_hier_count).start_date := hr_general.start_of_time;
2063: l_hierarchy_list(l_hier_count).end_date := hr_general.end_of_time;
2064: l_hierarchy_list(l_hier_count).elig_start_date := hr_general.start_of_time;
2065: l_hierarchy_list(l_hier_count).elig_end_date := hr_general.end_of_time;
2066: l_hier_count := l_hier_count+1;
2067: END LOOP;

Line 2064: l_hierarchy_list(l_hier_count).elig_start_date := hr_general.start_of_time;

2060: l_hierarchy_list(l_hier_count).pref_hierarchy_id := hier_rec.pref_hierarchy_id;
2061: l_hierarchy_list(l_hier_count).rule_evaluation_order := hier_rec.rule_evaluation_order;
2062: l_hierarchy_list(l_hier_count).start_date := hr_general.start_of_time;
2063: l_hierarchy_list(l_hier_count).end_date := hr_general.end_of_time;
2064: l_hierarchy_list(l_hier_count).elig_start_date := hr_general.start_of_time;
2065: l_hierarchy_list(l_hier_count).elig_end_date := hr_general.end_of_time;
2066: l_hier_count := l_hier_count+1;
2067: END LOOP;
2068: EXCEPTION

Line 2065: l_hierarchy_list(l_hier_count).elig_end_date := hr_general.end_of_time;

2061: l_hierarchy_list(l_hier_count).rule_evaluation_order := hier_rec.rule_evaluation_order;
2062: l_hierarchy_list(l_hier_count).start_date := hr_general.start_of_time;
2063: l_hierarchy_list(l_hier_count).end_date := hr_general.end_of_time;
2064: l_hierarchy_list(l_hier_count).elig_start_date := hr_general.start_of_time;
2065: l_hierarchy_list(l_hier_count).elig_end_date := hr_general.end_of_time;
2066: l_hier_count := l_hier_count+1;
2067: END LOOP;
2068: EXCEPTION
2069: WHEN NO_DATA_FOUND THEN null;

Line 3554: AND trunc(l_tc_date_to) = trunc(hr_general.end_of_time) THEN

3550: CLOSE get_tc_start_stop;
3551:
3552: IF trunc(l_tc_start_time) = trunc(p_start_evaluation_date)
3553: AND trunc(l_tc_stop_time) = trunc(p_end_evaluation_date)
3554: AND trunc(l_tc_date_to) = trunc(hr_general.end_of_time) THEN
3555:
3556:
3557: OPEN get_resp_id (l_detail_building_block_id, l_detail_building_block_ovn );
3558: FETCH get_resp_id into resp_id, resp_appl_id, l_tc_user_id;

Line 3815: IF time_periods(i).date_to <> hr_general.end_of_time

3811: -- end of time in the date_to column. For these timecards,
3812: -- neednt go to details, just get the responsibility which
3813: -- deleted the timecard.
3814:
3815: IF time_periods(i).date_to <> hr_general.end_of_time
3816: THEN
3817: OPEN get_tc_resp_id( time_periods(i).timecard_id,
3818: time_periods(i).timecard_ovn );
3819: FETCH get_tc_resp_id