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 1815: from hr_all_positions_f_tl pft

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

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

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