The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) gre_size, puar.tax_unit_id gre_id, htu.name gre_name
from pay_us_asg_reporting puar,
hr_tax_units_v htu
where puar.tax_unit_id=htu.tax_unit_id
and htu.business_group_id=c_business_group_id
and substr(puar.jurisdiction_code,1,2)=
nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
and htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
group by puar.tax_unit_id,htu.name
order by count(*);
select number_of_copies,
printer,
print_style,
save_output_flag
into copies_buffer,
printer_buffer,
style_buffer,
save_result
from fnd_concurrent_requests
where request_id = fnd_number.canonical_to_number(req_id);
select pdb.run_balance_status
into l_valid_status
from pay_defined_balances pdb,
pay_balance_types pbt,
pay_balance_dimensions pbd
where pdb.legislation_code = 'US'
and pdb.save_run_balance = 'Y'
and pdb.run_balance_status is not null
and pdb.balance_type_id = pbt.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.balance_name = 'SIT Withheld'
and pbd.database_item_suffix = '_GRE_JD_RUN';
select count(*) gre_size,puar.tax_unit_id gre_id,htu.name gre_name
from pay_us_asg_reporting puar,
hr_tax_units_v htu
where puar.tax_unit_id=htu.tax_unit_id
and htu.business_group_id=c_business_group_id
and substr(puar.jurisdiction_code,1,2)=
nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
and htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
group by puar.tax_unit_id,htu.name
order by count(*);
select number_of_copies,
printer,
print_style,
save_output_flag
into copies_buffer,
printer_buffer,
style_buffer,
save_result
from fnd_concurrent_requests
where request_id = fnd_number.canonical_to_number(req_id);