APPS.HR_PUMP_GET dependencies on PER_GRADES

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

2698: ) return number is
2699: l_grade_id number;
2700: begin
2701: -- Note that the grade name can be null on the
2702: -- per_grades table, but I think grades are created
2703: -- with a name - otherwise identifying them would be
2704: -- rather difficult...
2705: select gra.grade_id
2706: into l_grade_id

Line 2707: from per_grades_vl gra

2703: -- with a name - otherwise identifying them would be
2704: -- rather difficult...
2705: select gra.grade_id
2706: into l_grade_id
2707: from per_grades_vl gra
2708: where gra.name = p_grade_name
2709: and gra.business_group_id + 0 = p_business_group_id;
2710: return(l_grade_id);
2711: exception

Line 3375: per_grades_vl pg,

3371: begin
3372: select pgr.grade_rule_id
3373: into l_grade_rule_id
3374: from pay_grade_rules_f pgr,
3375: per_grades_vl pg,
3376: pay_rates pr
3377: where pg.name = p_grade_name
3378: and pg.business_group_id + 0 = p_business_group_id
3379: and pr.name = p_rate_name

Line 4186: per_grades_vl pg,

4182: begin
4183: select pgr.object_version_number
4184: into l_object_version_number
4185: from pay_grade_rules_f pgr,
4186: per_grades_vl pg,
4187: pay_rates pr
4188: where pg.name = p_grade_name
4189: and pg.business_group_id + 0 = p_business_group_id
4190: and pr.name = p_rate_name

Line 4473: ,per_grades pg

4469: begin
4470: select pgs.object_version_number
4471: into l_ovn
4472: from per_grade_spines_f pgs
4473: ,per_grades pg
4474: ,per_parent_spines pps
4475: where pg.name = p_grade
4476: and pg.grade_id = pgs.grade_id
4477: and pps.name = p_pay_scale