APPS.GHR_PEI_FLEX_DDF SQL Statements

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

Line: 34

		p_program_update_date		in	date		,
		p_pei_attribute_category	in	varchar2	,
		p_pei_attribute1			in	varchar2	,
		p_pei_attribute2			in	varchar2	,
		p_pei_attribute3			in	varchar2	,
		p_pei_attribute4			in	varchar2	,
		p_pei_attribute5			in	varchar2	,
		p_pei_attribute6			in	varchar2	,
		p_pei_attribute7			in	varchar2	,
		p_pei_attribute8			in	varchar2	,
		p_pei_attribute9			in	varchar2	,
		p_pei_attribute10			in	varchar2	,
		p_pei_attribute11			in	varchar2	,
		p_pei_attribute12			in	varchar2	,
		p_pei_attribute13			in	varchar2	,
		p_pei_attribute14			in	varchar2	,
		p_pei_attribute15			in	varchar2	,
		p_pei_attribute16			in	varchar2	,
		p_pei_attribute17			in	varchar2	,
		p_pei_attribute18			in	varchar2	,
		p_pei_attribute19			in	varchar2	,
		p_pei_attribute20			in	varchar2	,
		p_pei_information_category	in	varchar2	,
		p_pei_information1		in	varchar2	,
		p_pei_information2		in	varchar2	,
		p_pei_information3		in	varchar2	,
		p_pei_information4		in	varchar2	,
		p_pei_information5		in	varchar2	,
		p_pei_information6		in	varchar2	,
		p_pei_information7		in	varchar2	,
		p_pei_information8		in	varchar2	,
		p_pei_information9		in	varchar2	,
		p_pei_information10		in	varchar2	,
		p_pei_information11		in	varchar2	,
		p_pei_information12		in	varchar2	,
		p_pei_information13		in	varchar2	,
		p_pei_information14		in	varchar2	,
		p_pei_information15		in	varchar2	,
		p_pei_information16		in	varchar2	,
		p_pei_information17		in	varchar2	,
		p_pei_information18		in	varchar2	,
		p_pei_information19		in	varchar2	,
		p_pei_information20		in	varchar2	,
		p_pei_information21		in	varchar2	,
		p_pei_information22		in	varchar2	,
		p_pei_information23		in	varchar2	,
		p_pei_information24		in	varchar2	,
		p_pei_information25		in	varchar2	,
		p_pei_information26		in	varchar2	,
		p_pei_information27		in	varchar2	,
		p_pei_information28		in	varchar2	,
		p_pei_information29		in	varchar2	,
		p_pei_information30		in	varchar2
	) is

--
  l_proc       varchar2(72) := g_package||'ddf';

Line: 115

			  --  Validate OGHR roles (INSERT)
			  ghr_pei_flex_ddf.chk_oghr_roles
			    (p_person_extra_info_id => p_person_extra_info_id
			    ,p_information_type => p_information_type
			    ,p_person_id        => p_person_id
			    ,p_pei_information3 => p_pei_information3
			    ,p_pei_information4 => p_pei_information4
			    ,p_pei_information5 => p_pei_information5
			    ,p_pei_information6 => p_pei_information6
			    ,p_pei_information7 => p_pei_information7
			    ,p_pei_information8 => p_pei_information8
			    ,p_pei_information9 => p_pei_information9
			    ,p_pei_information10 => p_pei_information10
			   );

Line: 222

    SELECT count(*)
    INTO  l_count
    FROM   per_people_extra_info
    WHERE  information_type = p_information_type
    AND    person_id = p_person_id
    AND    pei_information3 = p_pei_information3
    AND    person_extra_info_id <> nvl(p_person_extra_info_id,-9999);

Line: 246

	    SELECT count(*)
	    INTO  l_count
	    FROM   per_people_extra_info
	    WHERE  information_type = p_information_type
	    AND    person_id = p_person_id
	    AND    pei_information10 = p_pei_information10
       AND    person_extra_info_id <> nvl(p_person_extra_info_id,-9999);

Line: 328

		SELECT pei_information5	race
		FROM per_people_extra_info
		WHERE person_id = c_person_id
		AND information_type = 'GHR_US_PER_GROUP1';