The following lines contain the word 'select', 'insert', 'update' or 'delete':
select upper(parameter_value)
from pay_action_parameters
where parameter_name='TRACE';
select full_name
from per_all_people_f
where person_id=p_person_id;
CURSOR csr_get_sel_type(p_selection_type varchar2) is
select meaning
from hr_lookups
where lookup_type = 'PAY_CA_ROE_SELECTION_TYPE'
and lookup_code = p_selection_type;
l_selection_type varchar2(80);
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = p_assignment_set;
IF p_selection_type is not null then
open csr_get_sel_type(p_selection_type);
Fetch csr_get_sel_type into l_selection_type;
CP_selection_type := l_selection_type;
cursor cur_lookup is select
meaning from hr_lookups
where lookup_type = 'PAY_CA_CORRESPONDENCE_LANGUAGE'
and lookup_code = ROE_PER_CORRESPONDENCE_LANG1;
select
ptpv.DISPLAY_PERIOD_TYPE
from
per_time_period_types_vl ptpv
where
ptpv.period_type = ROE_PAY_PERIOD_TYPE1;
Function CP_selection_type_p return varchar2 is
Begin
return CP_selection_type;