eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ORI_SHD SQL Statements

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

Line: 69


    select
       org_information_id
      ,org_information_context
      ,organization_id
      ,org_information1
      ,org_information10
      ,org_information11
      ,org_information12
      ,org_information13
      ,org_information14
      ,org_information15
      ,org_information16
      ,org_information17
      ,org_information18
      ,org_information19
      ,org_information2
      ,org_information20
      ,org_information3
      ,org_information4
      ,org_information5
      ,org_information6
      ,org_information7
      ,org_information8
      ,org_information9
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,object_version_number
    from hr_organization_information
    where   org_information_id = p_org_information_id;

Line: 183


    select
       org_information_id
      ,org_information_context
      ,organization_id
      ,org_information1
      ,org_information10
      ,org_information11
      ,org_information12
      ,org_information13
      ,org_information14
      ,org_information15
      ,org_information16
      ,org_information17
      ,org_information18
      ,org_information19
      ,org_information2
      ,org_information20
      ,org_information3
      ,org_information4
      ,org_information5
      ,org_information6
      ,org_information7
      ,org_information8
      ,org_information9
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,object_version_number
    from hr_organization_information
    where   org_information_id = p_org_information_id
    for  update nowait;

Line: 316


  ,p_program_update_date            in date
  ,p_attribute_category             in varchar2
  ,p_attribute1                     in varchar2
  ,p_attribute2                     in varchar2
  ,p_attribute3                     in varchar2
  ,p_attribute4                     in varchar2
  ,p_attribute5                     in varchar2
  ,p_attribute6                     in varchar2
  ,p_attribute7                     in varchar2
  ,p_attribute8                     in varchar2
  ,p_attribute9                     in varchar2
  ,p_attribute10                    in varchar2
  ,p_attribute11                    in varchar2
  ,p_attribute12                    in varchar2
  ,p_attribute13                    in varchar2
  ,p_attribute14                    in varchar2
  ,p_attribute15                    in varchar2
  ,p_attribute16                    in varchar2
  ,p_attribute17                    in varchar2
  ,p_attribute18                    in varchar2
  ,p_attribute19                    in varchar2
  ,p_attribute20                    in varchar2
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 374


  l_rec.program_update_date              := p_program_update_date;