APPS.HR_DEI_SHD SQL Statements

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

Line: 48

    select
       document_extra_info_id
      ,person_id
      ,document_type_id
      ,document_number
      ,date_from
      ,date_to
      ,issued_by
      ,issued_at
      ,issued_date
      ,issuing_authority
      ,verified_by
      ,verified_date
      ,related_object_name
      ,related_object_id_col
      ,related_object_id
      ,dei_attribute_category
      ,dei_attribute1
      ,dei_attribute2
      ,dei_attribute3
      ,dei_attribute4
      ,dei_attribute5
      ,dei_attribute6
      ,dei_attribute7
      ,dei_attribute8
      ,dei_attribute9
      ,dei_attribute10
      ,dei_attribute11
      ,dei_attribute12
      ,dei_attribute13
      ,dei_attribute14
      ,dei_attribute15
      ,dei_attribute16
      ,dei_attribute17
      ,dei_attribute18
      ,dei_attribute19
      ,dei_attribute20
      ,dei_attribute21
      ,dei_attribute22
      ,dei_attribute23
      ,dei_attribute24
      ,dei_attribute25
      ,dei_attribute26
      ,dei_attribute27
      ,dei_attribute28
      ,dei_attribute29
      ,dei_attribute30
      ,dei_information_category
      ,dei_information1
      ,dei_information2
      ,dei_information3
      ,dei_information4
      ,dei_information5
      ,dei_information6
      ,dei_information7
      ,dei_information8
      ,dei_information9
      ,dei_information10
      ,dei_information11
      ,dei_information12
      ,dei_information13
      ,dei_information14
      ,dei_information15
      ,dei_information16
      ,dei_information17
      ,dei_information18
      ,dei_information19
      ,dei_information20
      ,dei_information21
      ,dei_information22
      ,dei_information23
      ,dei_information24
      ,dei_information25
      ,dei_information26
      ,dei_information27
      ,dei_information28
      ,dei_information29
      ,dei_information30
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        hr_document_extra_info
    where       document_extra_info_id = p_document_extra_info_id;

Line: 195

    select
       document_extra_info_id
      ,person_id
      ,document_type_id
      ,document_number
      ,date_from
      ,date_to
      ,issued_by
      ,issued_at
      ,issued_date
      ,issuing_authority
      ,verified_by
      ,verified_date
      ,related_object_name
      ,related_object_id_col
      ,related_object_id
      ,dei_attribute_category
      ,dei_attribute1
      ,dei_attribute2
      ,dei_attribute3
      ,dei_attribute4
      ,dei_attribute5
      ,dei_attribute6
      ,dei_attribute7
      ,dei_attribute8
      ,dei_attribute9
      ,dei_attribute10
      ,dei_attribute11
      ,dei_attribute12
      ,dei_attribute13
      ,dei_attribute14
      ,dei_attribute15
      ,dei_attribute16
      ,dei_attribute17
      ,dei_attribute18
      ,dei_attribute19
      ,dei_attribute20
      ,dei_attribute21
      ,dei_attribute22
      ,dei_attribute23
      ,dei_attribute24
      ,dei_attribute25
      ,dei_attribute26
      ,dei_attribute27
      ,dei_attribute28
      ,dei_attribute29
      ,dei_attribute30
      ,dei_information_category
      ,dei_information1
      ,dei_information2
      ,dei_information3
      ,dei_information4
      ,dei_information5
      ,dei_information6
      ,dei_information7
      ,dei_information8
      ,dei_information9
      ,dei_information10
      ,dei_information11
      ,dei_information12
      ,dei_information13
      ,dei_information14
      ,dei_information15
      ,dei_information16
      ,dei_information17
      ,dei_information18
      ,dei_information19
      ,dei_information20
      ,dei_information21
      ,dei_information22
      ,dei_information23
      ,dei_information24
      ,dei_information25
      ,dei_information26
      ,dei_information27
      ,dei_information28
      ,dei_information29
      ,dei_information30
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        hr_document_extra_info
    where       document_extra_info_id = p_document_extra_info_id
    for update nowait;

Line: 415

  ,p_program_update_date            in date
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 506

  l_rec.program_update_date              := p_program_update_date;