APPS.PAY_EEI_MIG_SHD SQL Statements

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

Line: 64

    select
       element_type_extra_info_id
      ,element_type_id
      ,information_type
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,eei_attribute_category
      ,eei_attribute1
      ,eei_attribute2
      ,eei_attribute3
      ,eei_attribute4
      ,eei_attribute5
      ,eei_attribute6
      ,eei_attribute7
      ,eei_attribute8
      ,eei_attribute9
      ,eei_attribute10
      ,eei_attribute11
      ,eei_attribute12
      ,eei_attribute13
      ,eei_attribute14
      ,eei_attribute15
      ,eei_attribute16
      ,eei_attribute17
      ,eei_attribute18
      ,eei_attribute19
      ,eei_attribute20
      ,eei_information_category
      ,eei_information1
      ,eei_information2
      ,eei_information3
      ,eei_information4
      ,eei_information5
      ,eei_information6
      ,eei_information7
      ,eei_information8
      ,eei_information9
      ,eei_information10
      ,eei_information11
      ,eei_information12
      ,eei_information13
      ,eei_information14
      ,eei_information15
      ,eei_information16
      ,eei_information17
      ,eei_information18
      ,eei_information19
      ,eei_information20
      ,eei_information21
      ,eei_information22
      ,eei_information23
      ,eei_information24
      ,eei_information25
      ,eei_information26
      ,eei_information27
      ,eei_information28
      ,eei_information29
      ,eei_information30
      ,object_version_number
    from	pay_element_type_extra_info
    where	element_type_extra_info_id = p_element_type_extra_info_id;

Line: 189

    select
       element_type_extra_info_id
      ,element_type_id
      ,information_type
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,eei_attribute_category
      ,eei_attribute1
      ,eei_attribute2
      ,eei_attribute3
      ,eei_attribute4
      ,eei_attribute5
      ,eei_attribute6
      ,eei_attribute7
      ,eei_attribute8
      ,eei_attribute9
      ,eei_attribute10
      ,eei_attribute11
      ,eei_attribute12
      ,eei_attribute13
      ,eei_attribute14
      ,eei_attribute15
      ,eei_attribute16
      ,eei_attribute17
      ,eei_attribute18
      ,eei_attribute19
      ,eei_attribute20
      ,eei_information_category
      ,eei_information1
      ,eei_information2
      ,eei_information3
      ,eei_information4
      ,eei_information5
      ,eei_information6
      ,eei_information7
      ,eei_information8
      ,eei_information9
      ,eei_information10
      ,eei_information11
      ,eei_information12
      ,eei_information13
      ,eei_information14
      ,eei_information15
      ,eei_information16
      ,eei_information17
      ,eei_information18
      ,eei_information19
      ,eei_information20
      ,eei_information21
      ,eei_information22
      ,eei_information23
      ,eei_information24
      ,eei_information25
      ,eei_information26
      ,eei_information27
      ,eei_information28
      ,eei_information29
      ,eei_information30
      ,object_version_number
    from	pay_element_type_extra_info
    where	element_type_extra_info_id = p_element_type_extra_info_id
    for	update nowait;

Line: 307

  ,p_program_update_date            in date
  ,p_eei_attribute_category         in varchar2
  ,p_eei_attribute1                 in varchar2
  ,p_eei_attribute2                 in varchar2
  ,p_eei_attribute3                 in varchar2
  ,p_eei_attribute4                 in varchar2
  ,p_eei_attribute5                 in varchar2
  ,p_eei_attribute6                 in varchar2
  ,p_eei_attribute7                 in varchar2
  ,p_eei_attribute8                 in varchar2
  ,p_eei_attribute9                 in varchar2
  ,p_eei_attribute10                in varchar2
  ,p_eei_attribute11                in varchar2
  ,p_eei_attribute12                in varchar2
  ,p_eei_attribute13                in varchar2
  ,p_eei_attribute14                in varchar2
  ,p_eei_attribute15                in varchar2
  ,p_eei_attribute16                in varchar2
  ,p_eei_attribute17                in varchar2
  ,p_eei_attribute18                in varchar2
  ,p_eei_attribute19                in varchar2
  ,p_eei_attribute20                in varchar2
  ,p_eei_information_category       in varchar2
  ,p_eei_information1               in varchar2
  ,p_eei_information2               in varchar2
  ,p_eei_information3               in varchar2
  ,p_eei_information4               in varchar2
  ,p_eei_information5               in varchar2
  ,p_eei_information6               in varchar2
  ,p_eei_information7               in varchar2
  ,p_eei_information8               in varchar2
  ,p_eei_information9               in varchar2
  ,p_eei_information10              in varchar2
  ,p_eei_information11              in varchar2
  ,p_eei_information12              in varchar2
  ,p_eei_information13              in varchar2
  ,p_eei_information14              in varchar2
  ,p_eei_information15              in varchar2
  ,p_eei_information16              in varchar2
  ,p_eei_information17              in varchar2
  ,p_eei_information18              in varchar2
  ,p_eei_information19              in varchar2
  ,p_eei_information20              in varchar2
  ,p_eei_information21              in varchar2
  ,p_eei_information22              in varchar2
  ,p_eei_information23              in varchar2
  ,p_eei_information24              in varchar2
  ,p_eei_information25              in varchar2
  ,p_eei_information26              in varchar2
  ,p_eei_information27              in varchar2
  ,p_eei_information28              in varchar2
  ,p_eei_information29              in varchar2
  ,p_eei_information30              in varchar2
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 376

  l_rec.program_update_date              := p_program_update_date;