APPS.PER_QH_FIND_QUERY dependencies on BEN_PGM_F

Line 55: ,grade_ladder ben_pgm_f.name%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
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null

Line 222: from ben_pgm_f

218: cursor csr_grade_ladder
219: (p_grade_ladder_pgm_id number
220: ,p_effective_date date) is
221: select name
222: from ben_pgm_f
223: where pgm_id = p_grade_ladder_pgm_id
224: and p_effective_date between effective_start_date and effective_end_date;
225:
226: --

Line 661: ,'ben_pgm_f pgm','pgm.pgm_id','pgm.name');

657: l_a_where_clause:=build_grade_where(p_condition,p_value);
658: l_asg:=TRUE;
659: elsif p_field_name='GRADE_LADDER' then
660: l_a_where_clause:=build_varchar2_where('per_asg.grade_ladder_pgm_id',p_condition,p_value
661: ,'ben_pgm_f pgm','pgm.pgm_id','pgm.name');
662: l_asg:=TRUE;
663: elsif p_field_name='PEOPLE_GROUP' then
664: l_a_where_clause:=build_varchar2_where('per_asg.people_group_id',p_condition,p_value
665: ,'pay_people_groups pgp_a','pgp_a.people_group_id','pgp_a.group_name');

Line 1033: l_from_clause:=l_from_clause||',ben_pgm_f pgm';

1029: if grade_ladder_pgm_id is not null then
1030: l_where_clause:=l_where_clause||' and per_asg.grade_ladder_pgm_id='||grade_ladder_pgm_id;
1031: l_asg:=TRUE;
1032: elsif grade_ladder is not null then
1033: l_from_clause:=l_from_clause||',ben_pgm_f pgm';
1034: l_where_clause:=l_where_clause||' and per_asg.grade_ladder_pgm_id=pgm.pgm_id'
1035: ||' and upper(pgm.name) like ('''||upper(replace(grade_ladder,g_quote,g_quote||g_quote))||''')'
1036: --Modified for PMxbg
1037: ||' and gpm.business_group_id+0=nvl('||business_group_id||',gpm.business_group_id)'

Line 2481: ,grade_ladder in ben_pgm_f.name%type default null

2477: ,benefit_group in ben_benfts_grp.name%type default null
2478: ,benefit_group_id in per_all_people_f.benefit_group_id%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