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 PER_GRADES

Line 53: ,grade per_grades.name%type default null

49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null
52: ,benefit_group_id per_all_people_f.benefit_group_id%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

Line 215: from per_grades_vl

211: --
212: cursor csr_grade
213: (p_grade_id number) is
214: select name
215: from per_grades_vl
216: where grade_id=p_grade_id;
217: --
218: cursor csr_grade_ladder
219: (p_grade_ladder_pgm_id number

Line 549: ,'per_grades_vl grd_a','grd_a.grade_id','grd_a.name');

545: l_where varchar2(200);
546: begin
547: if p_condition in ('IS','IS_NOT','CONTAINS','STARTS','ENDS','NOT_CONTAINS','NULL','NOT_NULL') then
548: l_where:=build_varchar2_where('per_asg.grade_id',p_condition,p_value
549: ,'per_grades_vl grd_a','grd_a.grade_id','grd_a.name');
550: elsif p_condition in ('IS_LESS','IS_GREATER') then
551: l_where:='and per_asg.grade_id in (select grd_a.grade_id from per_grades_vl grd_a where grd_a.sequence';
552: if p_condition='IS_LESS' then
553: l_where:=l_where||' <=';

Line 551: l_where:='and per_asg.grade_id in (select grd_a.grade_id from per_grades_vl grd_a where grd_a.sequence';

547: if p_condition in ('IS','IS_NOT','CONTAINS','STARTS','ENDS','NOT_CONTAINS','NULL','NOT_NULL') then
548: l_where:=build_varchar2_where('per_asg.grade_id',p_condition,p_value
549: ,'per_grades_vl grd_a','grd_a.grade_id','grd_a.name');
550: elsif p_condition in ('IS_LESS','IS_GREATER') then
551: l_where:='and per_asg.grade_id in (select grd_a.grade_id from per_grades_vl grd_a where grd_a.sequence';
552: if p_condition='IS_LESS' then
553: l_where:=l_where||' <=';
554: else
555: l_where:=l_where||' >=';

Line 557: l_where:=l_where||'(select grd_a2.sequence from per_grades_vl grd_a2 where grd_a2.name like ('''

553: l_where:=l_where||' <=';
554: else
555: l_where:=l_where||' >=';
556: end if;
557: l_where:=l_where||'(select grd_a2.sequence from per_grades_vl grd_a2 where grd_a2.name like ('''
558: ||p_value||''') ) )';
559: end if;
560: return l_where;
561: end build_grade_where;

Line 1037: l_from_clause:=l_from_clause||',per_grades_vl grd';

1033: if grade_id is not null then
1034: l_where_clause:=l_where_clause||' and per_asg.grade_id='||grade_id;
1035: l_asg:=TRUE;
1036: elsif grade is not null then
1037: l_from_clause:=l_from_clause||',per_grades_vl grd';
1038: l_where_clause:=l_where_clause||' and per_asg.grade_id=grd.grade_id'
1039: ||' and upper(grd.name) like ('''||upper(replace(grade,g_quote,g_quote||g_quote))||''')'
1040: ||' and grd.business_group_id=per.business_group_id';
1041: l_asg:=TRUE;

Line 2495: ,grade in per_grades.name%type default null

2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null
2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2495: ,grade in per_grades.name%type default null
2496: ,grade_id in per_all_assignments_f.grade_id%type default null
2497: ,grade_ladder in ben_pgm_f.name%type default null
2498: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2499: ,position in hr_all_positions_f.name%type default null