APPS.OTA_OCL_SHD SQL Statements

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

Line: 52

    select
       competence_language_id
      ,competence_id
      ,language_code
      ,min_proficiency_level_id
      ,business_group_id
      ,object_version_number
      ,ocl_information_category
      ,ocl_information1
      ,ocl_information2
      ,ocl_information3
      ,ocl_information4
      ,ocl_information5
      ,ocl_information6
      ,ocl_information7
      ,ocl_information8
      ,ocl_information9
      ,ocl_information10
      ,ocl_information11
      ,ocl_information12
      ,ocl_information13
      ,ocl_information14
      ,ocl_information15
      ,ocl_information16
      ,ocl_information17
      ,ocl_information18
      ,ocl_information19
      ,ocl_information20
    from	ota_competence_languages
    where	competence_language_id = p_competence_language_id;

Line: 144

    select
       competence_language_id
      ,competence_id
      ,language_code
      ,min_proficiency_level_id
      ,business_group_id
      ,object_version_number
      ,ocl_information_category
      ,ocl_information1
      ,ocl_information2
      ,ocl_information3
      ,ocl_information4
      ,ocl_information5
      ,ocl_information6
      ,ocl_information7
      ,ocl_information8
      ,ocl_information9
      ,ocl_information10
      ,ocl_information11
      ,ocl_information12
      ,ocl_information13
      ,ocl_information14
      ,ocl_information15
      ,ocl_information16
      ,ocl_information17
      ,ocl_information18
      ,ocl_information19
      ,ocl_information20
    from	ota_competence_languages
    where	competence_language_id = p_competence_language_id
    for	update nowait;