APPS.HR_GENERAL dependencies on HR_ALL_POSITIONS_F

Line 185: from MLS table hr_all_positions_f_tl

181: b.legislation_code clause.
182: dsaxby 04-DEC-2002 115.48 2692195 Nocopy changes.
183: joward 09-DEC-2002 115.49 MLS enabled grade name
184: pmfletch 10-DEC-2002 115.50 Pointed decode_position_latest_name to select
185: from MLS table hr_all_positions_f_tl
186: joward 23-DEC-2002 115.51 MLS enabled job name
187: kjagadee 26-JUN-2003 115.52 2519443 Modified the cursor csr_amend_user_status
188: in function get_user_status, so that the
189: amends in status types will affect only the

Line 1813: from hr_all_positions_f_tl pft

1809: p_effective_date in date default null) return varchar2 is
1810: --
1811: cursor csr_latest_position is
1812: select pft.name
1813: from hr_all_positions_f_tl pft
1814: where pft.position_id = p_position_id
1815: and pft.language = userenv('LANG');
1816: --
1817: cursor csr_date_eff_position(p_position_id number, p_effective_date date) is

Line 1819: from hr_all_positions_f psf

1815: and pft.language = userenv('LANG');
1816: --
1817: cursor csr_date_eff_position(p_position_id number, p_effective_date date) is
1818: select psf.name
1819: from hr_all_positions_f psf
1820: where psf.position_id = p_position_id
1821: and p_effective_date between
1822: psf.effective_start_date and psf.effective_end_date;
1823: --

Line 1829: v_position_latest_name hr_all_positions_f_tl.name%TYPE := null;

1825: select effective_date
1826: from fnd_sessions
1827: where session_id = userenv('sessionid');
1828: --
1829: v_position_latest_name hr_all_positions_f_tl.name%TYPE := null;
1830: l_hr_pos_name_profile_value varchar2(20);
1831: l_effective_date date;
1832: --
1833: begin

Line 1971: from hr_all_positions_f

1967: p_position_id number) return number is
1968: --
1969: cursor csr_position is
1970: select position_definition_id
1971: from hr_all_positions_f
1972: where position_id = p_position_id
1973: and effective_end_date = hr_general.end_of_time;
1974: --
1975: v_position_definition_id number(20) := null;

Line 2000: from hr_all_positions_f psf

1996: p_availability_status_id number,p_effective_date date) return date is
1997: --
1998: cursor csr_avail_status is
1999: select psf.availability_status_id, psf.effective_start_date
2000: from hr_all_positions_f psf
2001: where psf.position_id = p_position_id
2002: and psf.effective_start_date < p_effective_date
2003: order by psf.effective_start_date desc;
2004: --

Line 2039: from hr_all_positions_f psf, per_shared_types sht

2035: l_effective_start_date date;
2036: --
2037: cursor csr_date_end is
2038: select psf.effective_start_date - 1
2039: from hr_all_positions_f psf, per_shared_types sht
2040: where psf.position_id = p_position_id
2041: and psf.availability_status_id = sht.shared_type_id
2042: and sht.system_type_cd in ('DELETED','ELIMINATED');
2043: --