APPS.OTA_NHS_SHD SQL Statements

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

Line: 74

    select
      nota_history_id,
   person_id,
   contact_id,
   trng_title,
   provider,
   type,
   centre,
   completion_date,
   award,
   rating,
   duration,
   duration_units,
   activity_version_id,
   status,
   verified_by_id,
   nth_information_category,
   nth_information1,
   nth_information2,
   nth_information3,
   nth_information4,
   nth_information5,
   nth_information6,
   nth_information7,
   nth_information8,
   nth_information9,
   nth_information10,
   nth_information11,
   nth_information12,
   nth_information13,
   nth_information15,
   nth_information16,
   nth_information17,
   nth_information18,
   nth_information19,
   nth_information20,
   org_id,
   object_version_number,
   business_group_id,
   nth_information14,
        customer_id,
        organization_id
    from ota_notrng_histories
    where   nota_history_id = p_nota_history_id;

Line: 185

    select  nota_history_id,
   person_id,
   contact_id,
   trng_title,
   provider,
   type,
   centre,
   completion_date,
   award,
   rating,
   duration,
   duration_units,
   activity_version_id,
   status,
   verified_by_id,
   nth_information_category,
   nth_information1,
   nth_information2,
   nth_information3,
   nth_information4,
   nth_information5,
   nth_information6,
   nth_information7,
   nth_information8,
   nth_information9,
   nth_information10,
   nth_information11,
   nth_information12,
   nth_information13,
   nth_information15,
   nth_information16,
   nth_information17,
   nth_information18,
   nth_information19,
   nth_information20,
   org_id,
   object_version_number,
   business_group_id,
   nth_information14,
        customer_id,
        organization_id
    from ota_notrng_histories
    where   nota_history_id = p_nota_history_id
    for  update nowait;