[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select to_number(UE.creator_id)
from ff_user_entities UE,
ff_database_items DI
where DI.user_name = p_db_item_name
and UE.user_entity_id = DI.user_entity_id
and Ue.creator_type = 'B'
and ue.legislation_code = 'US';
select paa.assignment_action_id
from pay_assignment_actions paa,
per_all_assignments_f paf,
pay_payroll_actions ppa,
pay_action_classifications pac
where paf.person_id = p_person_id
and paa.assignment_id = paf.assignment_id
and paa.tax_unit_id = w4_tax_unit_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.action_type = pac.action_type
and pac.classification_name = 'SEQUENCED'
and ppa.business_group_id = paf.business_group_id
and paf.payroll_id is not null
and ppa.effective_date +0 between paf.effective_start_date
and paf.effective_end_date
and ppa.effective_date +0 between w4_start_date
and w4_end_date
and ((nvl(paa.run_type_id, ppa.run_type_id) is null
and paa.source_action_id is null)
or (nvl(paa.run_type_id, ppa.run_type_id) is not null
and paa.source_action_id is not null )
or (ppa.action_type = 'V' and ppa.run_type_id is null
and paa.run_type_id is not null
and paa.source_action_id is null))
order by paa.action_sequence desc;
select paa1.assignment_action_id
into l_bal_aaid
from pay_assignment_actions paa1,
per_assignments_f paf2,
pay_payroll_actions ppa2,
pay_action_classifications pac2
where paf2.person_id = w4_person_id
and paa1.assignment_id = paf2.assignment_id
and paa1.tax_unit_id = w4_tax_unit_id
and paa1.payroll_action_id = ppa2.payroll_action_id
and ppa2.action_type = pac2.action_type
and pac2.classification_name = 'SEQUENCED'
and ppa2.effective_date between paf2.effective_start_date
and paf2.effective_end_date
and ppa2.effective_date between w4_start_date and
w4_end_date
and not exists (select ''
FROM pay_action_classifications pac,
pay_payroll_actions ppa,
pay_assignment_actions paa,
per_assignments_f paf1
WHERE paf1.person_id = w4_person_id
AND paa.assignment_id = paf1.assignment_id
AND paa.tax_unit_id = w4_tax_unit_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND ppa.effective_date between w4_start_date and
w4_end_date
AND paa.action_sequence > paa1.action_sequence
AND pac.action_type = ppa.action_type
AND pac.classification_name = 'SEQUENCED')
and rownum < 2;
select nvl(to_number(fed_information1),0),nvl(to_number(fed_information2),0)
into l_fed_allowance , l_fed_earnings
from pay_us_federal_tax_info_f
where fed_information_category = 'ALLOWANCES LIMIT';
select to_number(sta_information10),to_number(sta_information11)
into l_state_allowance , l_state_earnings
from pay_us_state_tax_info_f
where state_code = substr(w4_jurisdiction_code,1,2)
and effective_end_date = to_date('31/12/4712','DD/MM/YYYY')
and sta_information_category = 'State tax limit rate info';