The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
effort_report_approval_id
,effort_report_detail_id
,wf_role_name
,wf_orig_system_id
,wf_orig_system
,approver_order_num
,approval_status
,response_date
,actual_cost_share
,overwritten_effort_percent
,wf_item_key
,comments
,pera_information_category
,pera_information1
,pera_information2
,pera_information3
,pera_information4
,pera_information5
,pera_information6
,pera_information7
,pera_information8
,pera_information9
,pera_information10
,pera_information11
,pera_information12
,pera_information13
,pera_information14
,pera_information15
,pera_information16
,pera_information17
,pera_information18
,pera_information19
,pera_information20
,wf_role_display_name
,object_version_number
,notification_id
,eff_information_category
,eff_information1
,eff_information2
,eff_information3
,eff_information4
,eff_information5
,eff_information6
,eff_information7
,eff_information8
,eff_information9
,eff_information10
,eff_information11
,eff_information12
,eff_information13
,eff_information14
,eff_information15
from psp_eff_report_approvals
where effort_report_approval_id = p_effort_report_approval_id;
select
effort_report_approval_id
,effort_report_detail_id
,wf_role_name
,wf_orig_system_id
,wf_orig_system
,approver_order_num
,approval_status
,response_date
,actual_cost_share
,overwritten_effort_percent
,wf_item_key
,comments
,pera_information_category
,pera_information1
,pera_information2
,pera_information3
,pera_information4
,pera_information5
,pera_information6
,pera_information7
,pera_information8
,pera_information9
,pera_information10
,pera_information11
,pera_information12
,pera_information13
,pera_information14
,pera_information15
,pera_information16
,pera_information17
,pera_information18
,pera_information19
,pera_information20
,wf_role_display_name
,object_version_number
,notification_id
,eff_information_category
,eff_information1
,eff_information2
,eff_information3
,eff_information4
,eff_information5
,eff_information6
,eff_information7
,eff_information8
,eff_information9
,eff_information10
,eff_information11
,eff_information12
,eff_information13
,eff_information14
,eff_information15
from psp_eff_report_approvals
where effort_report_approval_id = p_effort_report_approval_id
for update nowait;