The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
salary_survey_line_id,
object_version_number,
salary_survey_id,
survey_job_name_code,
survey_region_code,
survey_seniority_code,
company_size_code,
industry_code,
survey_age_code,
start_date,
end_date,
currency_code,
differential,
minimum_pay,
mean_pay,
maximum_pay,
graduate_pay,
starting_pay,
percentage_change,
job_first_quartile,
job_median_quartile,
job_third_quartile,
job_fourth_quartile,
minimum_total_compensation,
mean_total_compensation,
maximum_total_compensation,
compnstn_first_quartile,
compnstn_median_quartile,
compnstn_third_quartile,
compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
tenth_percentile,
twenty_fifth_percentile,
fiftieth_percentile,
seventy_fifth_percentile,
ninetieth_percentile,
minimum_bonus,
mean_bonus,
maximum_bonus,
minimum_salary_increase,
mean_salary_increase,
maximum_salary_increase,
min_variable_compensation,
mean_variable_compensation,
max_variable_compensation,
minimum_stock,
mean_stock,
maximum_stock,
stock_display_type,
/* End Enhancement 4021737 */
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
/*Added for Enhancement 4021737*/
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30
/*Enhancement 4021737 */
from per_salary_survey_lines
where salary_survey_line_id = p_salary_survey_line_id;
select salary_survey_line_id,
object_version_number,
salary_survey_id,
survey_job_name_code,
survey_region_code,
survey_seniority_code,
company_size_code,
industry_code,
survey_age_code,
start_date,
end_date,
currency_code,
differential,
minimum_pay,
mean_pay,
maximum_pay,
graduate_pay,
starting_pay,
percentage_change,
job_first_quartile,
job_median_quartile,
job_third_quartile,
job_fourth_quartile,
minimum_total_compensation,
mean_total_compensation,
maximum_total_compensation,
compnstn_first_quartile,
compnstn_median_quartile,
compnstn_third_quartile,
compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
tenth_percentile,
twenty_fifth_percentile,
fiftieth_percentile,
seventy_fifth_percentile,
ninetieth_percentile,
minimum_bonus,
mean_bonus,
maximum_bonus,
minimum_salary_increase,
mean_salary_increase,
maximum_salary_increase,
min_variable_compensation,
mean_variable_compensation,
max_variable_compensation,
minimum_stock,
mean_stock,
maximum_stock,
stock_display_type,
/* End Enhancement 4021737 */
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
/*Added for Enhancement 4021737 */
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30
/*End Enhancement 4021737 */
from per_salary_survey_lines
where salary_survey_line_id = p_salary_survey_line_id
for update nowait;