DBA Data[Home] [Help]

APPS.GHR_POI_FLEX_DDF dependencies on PER_POSITION_DEFINITIONS

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