APPS.PE_POI_SHD SQL Statements

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

Line: 55

    select
        position_extra_info_id,
	position_id,
	information_type,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	poei_attribute_category,
	poei_attribute1,
	poei_attribute2,
	poei_attribute3,
	poei_attribute4,
	poei_attribute5,
	poei_attribute6,
	poei_attribute7,
	poei_attribute8,
	poei_attribute9,
	poei_attribute10,
	poei_attribute11,
	poei_attribute12,
	poei_attribute13,
	poei_attribute14,
	poei_attribute15,
	poei_attribute16,
	poei_attribute17,
	poei_attribute18,
	poei_attribute19,
	poei_attribute20,
	poei_information_category,
	poei_information1,
	poei_information2,
	poei_information3,
	poei_information4,
	poei_information5,
	poei_information6,
	poei_information7,
	poei_information8,
	poei_information9,
	poei_information10,
        poei_information11,
	poei_information12,
	poei_information13,
	poei_information14,
	poei_information15,
	poei_information16,
	poei_information17,
	poei_information18,
	poei_information19,
	poei_information20,
	poei_information21,
	poei_information22,
	poei_information23,
	poei_information24,
	poei_information25,
	poei_information26,
	poei_information27,
	poei_information28,
	poei_information29,
	poei_information30,
	object_version_number
    from	per_position_extra_info
    where	position_extra_info_id = p_position_extra_info_id;

Line: 185

    select
     	position_extra_info_id,
	position_id,
	information_type,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	poei_attribute_category,
	poei_attribute1,
	poei_attribute2,
	poei_attribute3,
	poei_attribute4,
	poei_attribute5,
	poei_attribute6,
	poei_attribute7,
	poei_attribute8,
	poei_attribute9,
	poei_attribute10,
	poei_attribute11,
	poei_attribute12,
	poei_attribute13,
	poei_attribute14,
	poei_attribute15,
	poei_attribute16,
	poei_attribute17,
	poei_attribute18,
	poei_attribute19,
	poei_attribute20,
	poei_information_category,
	poei_information1,
	poei_information2,
	poei_information3,
	poei_information4,
	poei_information5,
	poei_information6,
	poei_information7,
	poei_information8,
	poei_information9,
	poei_information10,
	poei_information11,
	poei_information12,
	poei_information13,
	poei_information14,
	poei_information15,
	poei_information16,
	poei_information17,
	poei_information18,
	poei_information19,
	poei_information20,
	poei_information21,
	poei_information22,
	poei_information23,
	poei_information24,
	poei_information25,
	poei_information26,
	poei_information27,
	poei_information28,
	poei_information29,
	poei_information30,
	object_version_number
    from	per_position_extra_info
    where	position_extra_info_id = p_position_extra_info_id
    for	update nowait;

Line: 305

        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,
        p_object_version_number         in number
        )

	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 378

  l_rec.program_update_date              := p_program_update_date;