DBA Data[Home] [Help]

APPS.PER_PMA_SHD SQL Statements

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

Line: 48

    select
       appraisal_period_id
      ,object_version_number
      ,plan_id
      ,appraisal_template_id
      ,start_date
      ,end_date
      ,task_start_date
      ,task_end_date
      ,initiator_code
      ,appraisal_system_type
      ,appraisal_type
      ,appraisal_assmt_status
      ,auto_conc_process
      ,days_before_task_st_dt
      ,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
    from        per_appraisal_periods
    where       appraisal_period_id = p_appraisal_period_id;
Line: 158

    select
       appraisal_period_id
      ,object_version_number
      ,plan_id
      ,appraisal_template_id
      ,start_date
      ,end_date
      ,task_start_date
      ,task_end_date
      ,initiator_code
      ,appraisal_system_type
      ,appraisal_type
      ,appraisal_assmt_status
      ,auto_conc_process
      ,days_before_task_st_dt
      ,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
    from        per_appraisal_periods
    where       appraisal_period_id = p_appraisal_period_id
    for update nowait;