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 1049: l_from_clause:=l_from_clause||',ben_pgm_f pgm';

1045: if grade_ladder_pgm_id is not null then
1046: l_where_clause:=l_where_clause||' and per_asg.grade_ladder_pgm_id='||grade_ladder_pgm_id;
1047: l_asg:=TRUE;
1048: elsif grade_ladder is not null then
1049: l_from_clause:=l_from_clause||',ben_pgm_f pgm';
1050: l_where_clause:=l_where_clause||' and per_asg.grade_ladder_pgm_id=pgm.pgm_id'
1051: ||' and upper(pgm.name) like ('''||upper(replace(grade_ladder,g_quote,g_quote||g_quote))||''')'
1052: --Modified for PMxbg
1053: ||' and gpm.business_group_id+0=nvl('||business_group_id||',gpm.business_group_id)'

Line 2497: ,grade_ladder in ben_pgm_f.name%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
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null