DBA Data[Home] [Help]

APPS.GHR_POI_FLEX_DDF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

		p_program_update_date		in	date		,
		p_poei_attribute_category	in	varchar2	,
		p_poei_attribute1		in	varchar2	,
		p_poei_attribute2		in	varchar2	,
		p_poei_attribute3		in	varchar2	,
		p_poei_attribute4		in	varchar2	,
		p_poei_attribute5		in	varchar2	,
		p_poei_attribute6		in	varchar2	,
		p_poei_attribute7		in	varchar2	,
		p_poei_attribute8		in	varchar2	,
		p_poei_attribute9		in	varchar2	,
		p_poei_attribute10		in	varchar2	,
		p_poei_attribute11		in	varchar2	,
		p_poei_attribute12		in	varchar2	,
		p_poei_attribute13		in	varchar2	,
		p_poei_attribute14		in	varchar2	,
		p_poei_attribute15		in	varchar2	,
		p_poei_attribute16		in	varchar2	,
		p_poei_attribute17		in	varchar2	,
		p_poei_attribute18		in	varchar2	,
		p_poei_attribute19		in	varchar2	,
		p_poei_attribute20		in	varchar2	,
		p_poei_information_category	in	varchar2	,
		p_poei_information1		in	varchar2	,
		p_poei_information2		in	varchar2	,
		p_poei_information3		in	varchar2	,
		p_poei_information4		in	varchar2	,
		p_poei_information5		in	varchar2	,
		p_poei_information6		in	varchar2	,
		p_poei_information7		in	varchar2	,
		p_poei_information8		in	varchar2	,
		p_poei_information9		in	varchar2	,
		p_poei_information10		in	varchar2	,
		p_poei_information11		in	varchar2	,
		p_poei_information12		in	varchar2	,
		p_poei_information13		in	varchar2	,
		p_poei_information14		in	varchar2	,
		p_poei_information15		in	varchar2	,
		p_poei_information16		in	varchar2	,
		p_poei_information17		in	varchar2	,
		p_poei_information18		in	varchar2	,
		p_poei_information19		in	varchar2	,
		p_poei_information20		in	varchar2	,
		p_poei_information21		in	varchar2	,
		p_poei_information22		in	varchar2	,
		p_poei_information23		in	varchar2	,
		p_poei_information24		in	varchar2	,
		p_poei_information25		in	varchar2	,
		p_poei_information26		in	varchar2	,
		p_poei_information27		in	varchar2	,
		p_poei_information28		in	varchar2	,
		p_poei_information29		in	varchar2	,
		p_poei_information30		in	varchar2
	)
is
--
  l_proc       varchar2(72) := g_package||'ddf';
Line: 86

select information6,segment1,segment2,segment3,segment4,
segment5,segment6,segment7
from per_position_definitions pdf, hr_all_positions_f pos
where
pos.position_definition_id = pdf.position_definition_id
and pos.position_id = p_position_id
and p_session_date between pos.effective_start_date and
pos.effective_end_date;
Line: 95

    select trunc(effective_date) session_date
      from fnd_sessions
      where session_id = (select userenv('sessionid') from dual);
Line: 235

select information6,segment1,segment2,segment3,segment4,
segment5,segment6,segment7
from per_position_definitions pdf, hr_all_positions_f pos
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = p_position_id
and p_session_date between pos.effective_start_date
and pos.effective_end_date;
Line: 243

    select trunc(effective_date) session_date
      from fnd_sessions
      where session_id = (select userenv('sessionid') from dual);
Line: 330

    select null
      from ghr_position_descriptions
    where position_description_id = to_number(p_pos_desc_id);