DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on HR_POSITIONS_F

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;