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_REPORTS dependencies on HR_POSITIONS

Line 314: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement

310: (p_position_id NUMBER) return VARCHAR2
311: --
312: AS
313: --
314: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement
315: --
316: l_position_name hr_positions.name%type;
317: --
318: begin

Line 316: l_position_name hr_positions.name%type;

312: AS
313: --
314: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement
315: --
316: l_position_name hr_positions.name%type;
317: --
318: begin
319: --
320: hr_utility.trace('Entered Get_position');

Line 324: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement

320: hr_utility.trace('Entered Get_position');
321: --
322: begin
323: --
324: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement
325: --
326: hr_utility.set_location('hr_reports.get_position',5);
327: SELECT name
328: INTO l_position_name

Line 329: FROM hr_positions

325: --
326: hr_utility.set_location('hr_reports.get_position',5);
327: SELECT name
328: INTO l_position_name
329: FROM hr_positions
330: WHERE position_id = p_position_id;
331: --
332: exception when NO_DATA_FOUND then null;
333: end;

Line 345: -- not session date, so selects from the hr_positions_f view rather than hr_positions view).

341: (p_position_id NUMBER,
342: p_effective_date DATE) return VARCHAR2
343: --
344: -- Returns position name on the effective date parameter (this is not necessarily same
345: -- not session date, so selects from the hr_positions_f view rather than hr_positions view).
346: --
347: AS
348: --
349: l_position_name hr_all_positions_f.name%type;

Line 361: FROM hr_positions_f paf

357: --
358: hr_utility.set_location('hr_reports.get_position',5);
359: SELECT name
360: INTO l_position_name
361: FROM hr_positions_f paf
362: WHERE paf.position_id = p_position_id
363: AND p_effective_date between paf.effective_start_date and paf.effective_end_date;
364: --
365: exception when NO_DATA_FOUND then null;