The following lines contain the word 'select', 'insert', 'update' or 'delete':
select distinct
payroll_id, first_period_end_date, period_type
into
l_payroll_id, l_fpe, l_period_type
from
pay_payrolls_f
where
payroll_name = p_payroll_name
and
p_effective_date between effective_start_date and effective_end_date;
select
min(end_date)
into
l_first_end_date
from
per_time_periods
where
payroll_id = l_payroll_id;
select
max(end_date)
into
l_last_end_date
from
per_time_periods
where
payroll_id = l_payroll_id;
select
rule_mode
into
l_tax_year_start
from
pay_legislation_rules
where
legislation_code = 'ZA'
and
rule_type = 'L';
select
fnd_date.canonical_to_date(org_information11)
into
l_fiscal_start
from
hr_organization_information
where
organization_id = p_business_group_id
and
org_information_context = 'Business Group Information';
select
end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
order by
end_date;
update
per_time_periods
set
pay_advice_date = l_previous_end_date
where
payroll_id = p_payroll_id
and
end_date between l_store_end_date and l_previous_end_date;
update
per_time_periods
set
pay_advice_date = l_old_end_date
where
payroll_id = p_payroll_id
and
end_date between l_end_date and p_last_end_date;
select
end_date, pay_advice_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
order by
end_date;
select
end_date, pay_advice_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date < p_first_end_date
order by
end_date desc;
select
start_date
into
l_start_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date = p_first_end_date;
select
max(end_date)
into
l_store_end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
pay_advice_date = l_old_pay_me;
select
max(end_date)
into
l_store_end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
pay_advice_date = l_pay_me;
update
per_time_periods
set
prd_information1 = to_char(l_tax_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and l_store_end_date;
select
number_per_fiscal_year
into
l_no_periods
from
per_time_period_types
where
period_type = p_proc_period_type;
update
per_time_periods
set
prd_information1 = to_char(l_tax_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and p_last_end_date;
update
per_time_periods
set
prd_information1 = to_char(l_tax_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and p_last_end_date;
update
per_time_periods
set
prd_information1 = to_char(l_tax_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and l_store_end_date;
select
end_date, pay_advice_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
order by
end_date;
select
start_date
into
l_start_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date = p_first_end_date;
select
max(end_date)
into
l_store_end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
pay_advice_date = l_old_pay_me;
select
max(end_date)
into
l_store_end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
pay_advice_date = l_pay_me;
update
per_time_periods
set
prd_information3 = to_char(l_cal_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and l_store_end_date;
select
number_per_fiscal_year
into
l_no_periods
from
per_time_period_types
where
period_type = p_proc_period_type;
update
per_time_periods
set
prd_information3 = to_char(l_cal_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and p_last_end_date;
update
per_time_periods
set
prd_information3 = to_char(l_cal_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and p_last_end_date;
update
per_time_periods
set
prd_information3 = to_char(l_cal_year, 'YYYY'),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and l_store_end_date;
select
end_date, pay_advice_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
and
prd_information1 > c_tax_year
order by
end_date;
select
end_date, pay_advice_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
prd_information1 = c_tax_year
order by
end_date DESC;
select
prd_information1
into
l_tax_year
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date = p_first_end_date;
update
per_time_periods
set
prd_information2 = to_char(l_quarter),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_end_date and l_old_end_date;
update
per_time_periods
set
prd_information2 = to_char(l_quarter),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_end_date and l_old_end_date;
update
per_time_periods
set
prd_information2 = to_char(l_quarter),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and l_end_date;
update
per_time_periods
set
prd_information2 = to_char(l_quarter),
prd_information_category = 'ZA'
where
payroll_id = p_payroll_id
and
end_date between l_old_end_date and l_end_date;
select distinct
prd_information1
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
order by
prd_information1;
select
rowid, end_date
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date between p_first_end_date and p_last_end_date
and
prd_information1 = c_tax_year
order by
end_date;
select
period_num
into
l_period
from
per_time_periods
where
payroll_id = p_payroll_id
and
end_date = p_first_end_date;
update
per_time_periods
set
period_num = l_period
where
rowid = l_rowid;
update
per_time_periods
set
period_name = to_char(l_period) || ' ' || to_char(l_end_date, 'YYYY')
|| ' ' || p_proc_period_type
where
rowid = l_rowid;