[Home] [Help]
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
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
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