APPS.OTA_TPS_SHD SQL Statements

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

Line: 64

    select
       training_plan_id
      ,time_period_id
      ,plan_status_type_id
      ,organization_id
      ,person_id
      ,budget_currency
      ,name
      ,description
      ,business_group_id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,plan_source --changed
      ,start_date
      ,end_date
      ,creator_person_id
      ,additional_member_flag
      ,learning_path_id
      -- Modified for Bug#3479186
      ,contact_id
    from	ota_training_plans
    where	training_plan_id = p_training_plan_id;

Line: 178

    select
       training_plan_id
      ,time_period_id
      ,plan_status_type_id
      ,organization_id
      ,person_id
      ,budget_currency
      ,name
      ,description
      ,business_group_id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,plan_source --changed
      ,start_date
      ,end_date
      ,creator_person_id
      ,additional_member_flag
      ,learning_path_id
      ,contact_id
    from	ota_training_plans
    where	training_plan_id = p_training_plan_id
    for	update nowait;