APPS.HR_GENERAL dependencies on HR_ALL_POSITIONS

Line 118: hr_all_positions in decode_position

114: hsajja 01-OCT-99 115.13 Added DECODE_LATEST_POSITION_DEF_ID,
115: DECODE_AVAIL_STATUS_START_DATE functions
116: hsajja 04-OCT-99 115.14 Added GET_POSITION_DATE_END function
117: Changed per_all_positions to
118: hr_all_positions in decode_position
119: function
120: hsajja 07-OCT-99 115.15 Added functions DECODE_PERSON_NAME,
121: DECODE_GRADE_RULE.
122: hsajja 12-OCT-99 115.16 Modified DECODE_POSITION_LATEST_NAME,

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 1041: from hr_all_positions

1037: p_position_id number) return varchar2 is
1038: --
1039: cursor csr_lookup is
1040: select name
1041: from hr_all_positions
1042: where position_id = p_position_id;
1043: --
1044: v_meaning hr_all_positions.name%TYPE := null;
1045: --

Line 1044: v_meaning hr_all_positions.name%TYPE := null;

1040: select name
1041: from hr_all_positions
1042: where position_id = p_position_id;
1043: --
1044: v_meaning hr_all_positions.name%TYPE := null;
1045: --
1046: begin
1047: --
1048: -- Only open the cursor if the parameter is going to retrieve anything

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 1821: from hr_all_positions_f psf

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

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

Line 1973: from hr_all_positions_f

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

Line 2002: from hr_all_positions_f psf

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

Line 2041: from hr_all_positions_f psf, per_shared_types sht

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