The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
template_id
,template_name
,business_group_id
,set_of_books_id
,object_version_number
,report_type
,period_frequency_id
,report_template_code
,display_all_emp_distrib_flag
,manual_entry_override_flag
,approval_type
,custom_approval_code
,sup_levels
,preview_effort_report_flag
,notification_reminder_in_days
,sprcd_tolerance_amt
,sprcd_tolerance_percent
,description
,legislation_code
,hundred_pcent_eff_at_per_asg
,selection_match_level
from psp_report_templates
where template_id = p_template_id;
select
template_id
,template_name
,business_group_id
,set_of_books_id
,object_version_number
,report_type
,period_frequency_id
,report_template_code
,display_all_emp_distrib_flag
,manual_entry_override_flag
,approval_type
,custom_approval_code
,sup_levels
,preview_effort_report_flag
,notification_reminder_in_days
,sprcd_tolerance_amt
,sprcd_tolerance_percent
,description
,legislation_code
,hundred_pcent_eff_at_per_asg
,selection_match_level
from psp_report_templates
where template_id = p_template_id
for update nowait;
,p_selection_match_level in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.selection_match_level := p_selection_match_level;