APPS.HR_UTIL_MISC_SS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2195: oname hr_all_organization_units_tl.name%type := ''; --14592612

2191: function getOrgName (p_org_id in number, p_bg_id in number)
2192: return varchar2
2193: is
2194: --oname varchar2(200) := '';
2195: oname hr_all_organization_units_tl.name%type := ''; --14592612
2196: begin
2197:
2198: select name
2199: into oname

Line 2200: from hr_all_organization_units_tl

2196: begin
2197:
2198: select name
2199: into oname
2200: from hr_all_organization_units_tl
2201: where p_org_id = organization_id
2202: and language(+) = userenv('LANG');
2203:
2204: return oname;

Line 2498: l_org_name hr_all_organization_units_tl.name%type := ''; --14592612

2494:
2495: --l_org_id number(10):=-1;
2496: l_org_id per_all_assignments_f.ORGANIZATION_ID%type := -1; --14592612
2497: --l_org_name varchar2(100) := null;
2498: l_org_name hr_all_organization_units_tl.name%type := ''; --14592612
2499: begin
2500:
2501: if(p_rptg_grp_id is not null and p_plan_id is null) then
2502: begin