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.PER_QH_FIND_QUERY dependencies on HR_ALL_POSITIONS_F

Line 57: ,position hr_all_positions_f.name%type default null

53: ,grade per_grades.name%type default null
54: ,grade_id per_all_assignments_f.grade_id%type default null
55: ,grade_ladder ben_pgm_f.name%type default null
56: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null

Line 233: from hr_all_positions_f_tl

229: cursor csr_position
230: (p_position_id number
231: ,p_effective_date date) is
232: select name
233: from hr_all_positions_f_tl
234: where position_id=p_position_id
235: and language = userenv('LANG');
236: --PMFLETCH - No effective date in tl table
237: --and p_effective_date between effective_start_date and effective_end_date;

Line 654: ,'hr_all_positions_f_vl pos_a','pos_a.position_id','pos_a.name'); -- Bug 3891920

650: l_asg:=TRUE;
651: elsif p_field_name='POSITION' then
652: -- PMFLETCH - Now using VL translation table
653: l_a_where_clause:=build_varchar2_where('per_asg.position_id',p_condition,p_value
654: ,'hr_all_positions_f_vl pos_a','pos_a.position_id','pos_a.name'); -- Bug 3891920
655: l_asg:=TRUE;
656: elsif p_field_name='GRADE' then
657: l_a_where_clause:=build_grade_where(p_condition,p_value);
658: l_asg:=TRUE;

Line 1048: l_from_clause:=l_from_clause||',hr_all_positions_f_vl per_pos'; -- Bug 3891920

1044: l_where_clause:=l_where_clause||' and per_asg.position_id='||position_id;
1045: l_asg:=TRUE;
1046: elsif position is not null then
1047: -- PMFLETCH - Now using VL translation table
1048: l_from_clause:=l_from_clause||',hr_all_positions_f_vl per_pos'; -- Bug 3891920
1049: l_where_clause:=l_where_clause||' and per_asg.position_id=per_pos.position_id'
1050: ||' and upper(per_pos.name) like ('''||upper(replace(position,g_quote,g_quote||g_quote))||''')'
1051: ||' and per_pos.business_group_id=per.business_group_id';
1052: l_asg:=TRUE;

Line 2483: ,position in hr_all_positions_f.name%type default null

2479: ,grade in per_grades.name%type default null
2480: ,grade_id in per_all_assignments_f.grade_id%type default null
2481: ,grade_ladder in ben_pgm_f.name%type default null
2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2483: ,position in hr_all_positions_f.name%type default null
2484: ,position_id in per_all_assignments_f.position_id%type default null
2485: ,job in per_jobs.name%type default null
2486: ,job_id in per_all_assignments_f.job_id%type default null
2487: ,assignment_status_type in per_assignment_status_types.user_status%type default null