eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_UTIL_MISC_SS dependencies on HR_LOCATIONS_ALL_TL

Line 2212: lname hr_locations_all_tl.location_code%type := ''; --14592612

2208: function getLocName (p_loc_id in number, p_bg_id in number)
2209: return varchar2
2210: is
2211: --lname varchar2(200) := '';
2212: lname hr_locations_all_tl.location_code%type := ''; --14592612
2213: begin
2214:
2215: select location_code
2216: into lname

Line 2217: from hr_locations_all_tl

2213: begin
2214:
2215: select location_code
2216: into lname
2217: from hr_locations_all_tl
2218: where p_loc_id = location_id
2219: and language(+) = userenv('LANG');
2220:
2221: return lname;

Line 2534: l_loc_name hr_locations_all_tl.location_code%type := ''; --14592612

2530:
2531: --l_loc_id number(10):=-1;
2532: l_loc_id per_all_assignments_f.Location_ID%type := -1; --14592612
2533: --l_loc_name varchar2(100) := null;
2534: l_loc_name hr_locations_all_tl.location_code%type := ''; --14592612
2535: begin
2536: -- hr_utility.trace_on(null,'ORCL');
2537: if(p_rptg_grp_id is not null and p_plan_id is null) then
2538: begin