APPS.HR_PUMP_GET dependencies on PER_GRADES

Line 2675: -- per_grades table, but I think grades are created

2671: ) return number is
2672: l_grade_id number;
2673: begin
2674: -- Note that the grade name can be null on the
2675: -- per_grades table, but I think grades are created
2676: -- with a name - otherwise identifying them would be
2677: -- rather difficult...
2678: select gra.grade_id
2679: into l_grade_id

Line 2680: from per_grades_vl gra

2676: -- with a name - otherwise identifying them would be
2677: -- rather difficult...
2678: select gra.grade_id
2679: into l_grade_id
2680: from per_grades_vl gra
2681: where gra.name = p_grade_name
2682: and gra.business_group_id + 0 = p_business_group_id;
2683: return(l_grade_id);
2684: exception

Line 3348: per_grades_vl pg,

3344: begin
3345: select pgr.grade_rule_id
3346: into l_grade_rule_id
3347: from pay_grade_rules_f pgr,
3348: per_grades_vl pg,
3349: pay_rates pr
3350: where pg.name = p_grade_name
3351: and pg.business_group_id + 0 = p_business_group_id
3352: and pr.name = p_rate_name

Line 4159: per_grades_vl pg,

4155: begin
4156: select pgr.object_version_number
4157: into l_object_version_number
4158: from pay_grade_rules_f pgr,
4159: per_grades_vl pg,
4160: pay_rates pr
4161: where pg.name = p_grade_name
4162: and pg.business_group_id + 0 = p_business_group_id
4163: and pr.name = p_rate_name

Line 4446: ,per_grades pg

4442: begin
4443: select pgs.object_version_number
4444: into l_ovn
4445: from per_grade_spines_f pgs
4446: ,per_grades pg
4447: ,per_parent_spines pps
4448: where pg.name = p_grade
4449: and pg.grade_id = pgs.grade_id
4450: and pps.name = p_pay_scale