APPS.GHR_POI_FLEX_DDF dependencies on HR_ALL_POSITIONS_F

Line 88: from per_position_definitions pdf, hr_all_positions_f pos

84: --
85: cursor c_pos_segments(p_session_date in fnd_sessions.effective_date%type) is
86: select information6,segment1,segment2,segment3,segment4,
87: segment5,segment6,segment7
88: from per_position_definitions pdf, hr_all_positions_f pos
89: where
90: pos.position_definition_id = pdf.position_definition_id
91: and pos.position_id = p_position_id
92: and p_session_date between pos.effective_start_date and

Line 131: -- Fetch the current segments from hr_all_positions_f

127: l_session_date := trunc(sysdate);
128: for ses_rec in c_get_session_date loop
129: l_session_date := ses_rec.session_date;
130: end loop;
131: -- Fetch the current segments from hr_all_positions_f
132: for c_pos_rec in c_pos_segments(l_session_date) loop
133: -- Do not allow modification of EIT segments which are populated
134: -- from the Position KFF
135: -- GHR_US_POS_GRP1 --> Personnel Officer ID

Line 237: from per_position_definitions pdf, hr_all_positions_f pos

233: --
234: cursor c_pos_segments(p_session_date in date) is
235: select information6,segment1,segment2,segment3,segment4,
236: segment5,segment6,segment7
237: from per_position_definitions pdf, hr_all_positions_f pos
238: where pos.position_definition_id = pdf.position_definition_id
239: and pos.position_id = p_position_id
240: and p_session_date between pos.effective_start_date
241: and pos.effective_end_date;

Line 257: -- Fetch the current segments from hr_all_positions_f

253: for ses_rec in c_get_session_date loop
254: l_session_date := ses_rec.session_date;
255: end loop;
256:
257: -- Fetch the current segments from hr_all_positions_f
258: for c_pos_rec in c_pos_segments(l_session_date) loop
259: -- Do not allow modification of EIT segments which are populated
260: -- from the Position KFF
261: -- GHR_US_POS_GRP1 --> Personnel Officer ID