DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_GRADES_VL

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