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 BEN_BENFTS_GRP

Line 51: ,benefit_group ben_benfts_grp.name%type default null

47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%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

Line 163: from ben_benfts_grp

159: --
160: cursor csr_benfts_grp
161: (p_benfts_grp_id NUMBER) is
162: select name
163: from ben_benfts_grp
164: where benfts_grp_id=p_benfts_grp_id;
165: --
166: per_rec per_all_people_f%rowtype;
167: cursor csr_assignment_details

Line 637: ,'ben_benfts_grp ben_a','ben_a.benfts_grp_id','ben_a.name');

633: elsif p_field_name='BENEFITS_GROUP' then
634: -- Bug 4060365 Changed the parameter from per.benefit_group to per.benefit_group_id and
635: -- ben_a.benefit_group_id to ben_a.benfts_grp_id
636: l_a_where_clause:=build_varchar2_where('per.benefit_group_id',p_condition,p_value
637: ,'ben_benfts_grp ben_a','ben_a.benfts_grp_id','ben_a.name');
638: elsif p_field_name='VACANCY' then
639: l_a_where_clause:=build_varchar2_where('per_asg.vacancy_id',p_condition,p_value
640: ,'per_all_vacancies vac_a','vac_a.vacancy_id','vac_a.name');
641: l_asg:=TRUE;

Line 971: l_from_clause:=l_from_clause||',ben_benfts_grp per_ben';

967: --
968: if benefit_group_id is not null then
969: l_where_clause:=l_where_clause||' and per.benefit_group_id='||benefit_group_id;
970: elsif benefit_group is not null then
971: l_from_clause:=l_from_clause||',ben_benfts_grp per_ben';
972: l_where_clause:=l_where_clause||' and per.benefit_group_id=per_ben.benefit_group_id'
973: ||' and upper(per_ben.name) like ('''||upper(replace(benefit_group,g_quote,g_quote||g_quote))||''')';
974: end if;
975: --

Line 2493: ,benefit_group in ben_benfts_grp.name%type default null

2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%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