[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select substr(legislative_parameters,
instr(legislative_parameters, p_token) + (length (p_token) + 1),
(decode(instr (legislative_parameters, ' ', instr (legislative_parameters, p_token)),
0, decode (instr (legislative_parameters, p_token),0, .5,length (legislative_parameters)),
instr (legislative_parameters, ' ', instr (legislative_parameters, p_token)) -
(instr (legislative_parameters, p_token) + (length (p_token) + 1))))),
business_group_id,
request_id,
start_date,
effective_date -- this will be the benefit end date
from pay_payroll_actions
where payroll_action_id = p_pact_id;
select org.org_information11,
substr(org.org_information3,1,36),
org.org_information13
from hr_organization_information org
where org.organization_id = p_business_group_id
and upper(org.org_information1) = upper(p_tax_ref)
and org.org_information_context = 'Tax Details References';
select count(*),
action_information6
from pay_assignment_actions paa,
pay_action_information pai
where paa.payroll_action_id = p_pact_id
and pai.action_context_id = paa.assignment_action_id
and pai.action_information_category = 'EMEA PAYROLL INFO'
and pai.action_context_type = 'AAP'
group by action_information6;
sqlstr := 'SELECT DISTINCT person_id
FROM per_people_f ppf,
pay_payroll_actions ppa
WHERE ppa.payroll_action_id = :payroll_action_id
AND ppa.business_group_id +0= ppf.business_group_id
ORDER BY ppf.person_id';
select /*+ ordered
use_nl(paa,pai_person)
use_index(pai_person,pay_action_information_n2) */
distinct paa.assignment_id
from pay_assignment_actions paa,
pay_action_information pai_person,
pay_action_information pai_emp
where paa.payroll_action_id = v_archive_payroll_action_id
and pai_person.action_context_id = paa.assignment_action_id
and pai_person.action_information_category = 'ADDRESS DETAILS'
and pai_person.action_information14 = 'Employee Address'
and pai_person.action_information1 between stperson and endperson
and pai_person.action_context_type = 'AAP'
and pai_emp.action_context_id = paa.assignment_action_id
and pai_emp.action_context_type = 'AAP'
and pai_emp.action_information_category = 'EMEA PAYROLL INFO'
and (v_tax_ref is null
or
pai_emp.action_information6 = v_tax_ref)
order by paa.assignment_id;
SELECT pay_assignment_actions_s.nextval
INTO l_ass_act_id
FROM dual;
select
decode(sign(l_input_value),
1,lpad(trunc(l_input_value),l_cut_to_size,0),
0,lpad(trunc(l_input_value),l_cut_to_size,0),
-1,'-' || lpad(trunc(abs(l_input_value)),l_cut_to_size-1,0)
) into l_output_value
from dual;
/* select upper(description) into l_description
from fnd_lookup_values flv
where flv.lookup_type = l_lookup_type
and flv.lookup_code = l_lookup_code
and flv.ENABLED_FLAG = 'Y'
and fnd_date.canonical_to_date(l_effective_date) between
nvl(flv.START_DATE_ACTIVE,
fnd_date.canonical_to_date(l_effective_date)) and
nvl(flv.END_DATE_ACTIVE,
fnd_date.canonical_to_date(l_effective_date));*/
select upper(description) into l_description
from hr_lookups hlu
where hlu.lookup_type = l_lookup_type
and hlu.lookup_code = l_lookup_code
and hlu.ENABLED_FLAG = 'Y'
and fnd_date.canonical_to_date(l_effective_date) between
nvl(hlu.START_DATE_ACTIVE,
fnd_date.canonical_to_date(l_effective_date)) and
nvl(hlu.END_DATE_ACTIVE,
fnd_date.canonical_to_date(l_effective_date));