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.PSP_GENERAL dependencies on HR_POSITIONS_F

Line 2028: from hr_positions_f hpf

2024: IS
2025:
2026: cursor eff_dates is
2027: select max(hpf.effective_end_date),min(hpf.effective_start_date)
2028: from hr_positions_f hpf
2029: WHERE hpf.position_id = p_position_id;
2030:
2031: max_eff_end_date date;
2032: min_eff_start_date date;

Line 2060: from hr_positions_f hpf

2056: FUNCTION get_position_name_er(p_position_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2057:
2058: cursor eff_dates is
2059: select max(hpf.effective_end_date),min(hpf.effective_start_date)
2060: from hr_positions_f hpf
2061: WHERE hpf.position_id = p_position_id ;
2062:
2063: cursor c1(p_calculated_date date)
2064: is

Line 2066: from hr_positions_f hpf

2062:
2063: cursor c1(p_calculated_date date)
2064: is
2065: select name
2066: from hr_positions_f hpf
2067: WHERE hpf.position_id = p_position_id
2068: and p_calculated_date between hpf.effective_start_date and hpf.effective_end_date;
2069:
2070: l_position_name varchar2(240);