APPS.PER_BPR_SHD SQL Statements

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

Line: 64

    select
      payroll_run_id,
      payroll_id,
      business_group_id,
      payroll_identifier,
      period_start_date,
      period_end_date,
      processing_date,
      object_version_number,
      bpr_attribute_category,
      bpr_attribute1,
      bpr_attribute2,
      bpr_attribute3,
      bpr_attribute4,
      bpr_attribute5,
      bpr_attribute6,
      bpr_attribute7,
      bpr_attribute8,
      bpr_attribute9,
      bpr_attribute10,
      bpr_attribute11,
      bpr_attribute12,
      bpr_attribute13,
      bpr_attribute14,
      bpr_attribute15,
      bpr_attribute16,
      bpr_attribute17,
      bpr_attribute18,
      bpr_attribute19,
      bpr_attribute20,
      bpr_attribute21,
      bpr_attribute22,
      bpr_attribute23,
      bpr_attribute24,
      bpr_attribute25,
      bpr_attribute26,
      bpr_attribute27,
      bpr_attribute28,
      bpr_attribute29,
      bpr_attribute30
    from	per_bf_payroll_runs
    where	payroll_run_id = p_payroll_run_id;

Line: 173

    select       payroll_run_id,
      payroll_id,
      business_group_id,
      payroll_identifier,
      period_start_date,
      period_end_date,
      processing_date,
      object_version_number,
      bpr_attribute_category,
      bpr_attribute1,
      bpr_attribute2,
      bpr_attribute3,
      bpr_attribute4,
      bpr_attribute5,
      bpr_attribute6,
      bpr_attribute7,
      bpr_attribute8,
      bpr_attribute9,
      bpr_attribute10,
      bpr_attribute11,
      bpr_attribute12,
      bpr_attribute13,
      bpr_attribute14,
      bpr_attribute15,
      bpr_attribute16,
      bpr_attribute17,
      bpr_attribute18,
      bpr_attribute19,
      bpr_attribute20,
      bpr_attribute21,
      bpr_attribute22,
      bpr_attribute23,
      bpr_attribute24,
      bpr_attribute25,
      bpr_attribute26,
      bpr_attribute27,
      bpr_attribute28,
      bpr_attribute29,
      bpr_attribute30
    from	per_bf_payroll_runs
    where	payroll_run_id = p_payroll_run_id
    for	update nowait;