APPS.HR_GENERAL dependencies on HR_ALL_POSITIONS_F_TL

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 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