DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_GRADES_TL

Line 2177: gname per_grades_tl.name%type := ''; --14592612

2173: function getGradeName (p_grade_id in number, p_bg_id in number)
2174: return varchar2
2175: is
2176: --gname varchar2(200) := '';
2177: gname per_grades_tl.name%type := ''; --14592612
2178: begin
2179:
2180: select name
2181: into gname

Line 2182: from per_grades_tl

2178: begin
2179:
2180: select name
2181: into gname
2182: from per_grades_tl
2183: where p_grade_id = grade_id
2184: and language(+) = userenv('LANG');
2185:
2186: return hr_util_misc_ss.getObjectName('GRADE', p_grade_id, p_bg_id, gname);

Line 2461: l_grade_name per_grades_tl.name%type := ''; --14592612

2457:
2458: --l_grade_id number(10):=-1;
2459: l_grade_id per_all_assignments_f.grade_id%type := -1; --14592612
2460: --l_grade_name varchar2(100) := null;
2461: l_grade_name per_grades_tl.name%type := ''; --14592612
2462: begin
2463:
2464: if(p_rptg_grp_id is not null and p_plan_id is null) then
2465: begin