[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select *
from pay_stat_trans_audit
where source4_type = 'TRANSACTION_ID'
and source4 = ln_transaction_id;
select pus.state_name
from pay_stat_trans_audit pta
,pay_us_states pus
where pta.source4 = ln_transaction_id
and pus.state_code = substr(pta.source1,1,2)
and exists(select 'x' from pay_us_state_tax_info_f stif
where stif.state_code = pus.state_code
and stif.sta_information7 = 'Y'
and stif.sta_information9 = 'Y'
and pta.transaction_effective_date between
stif.effective_start_date and
stif.effective_end_date);
select pus.state_name
from pay_stat_trans_audit pta
,pay_us_states pus
where pta.source4 = ln_transaction_id
and pus.state_code = substr(pta.source1,1,2)
and exists(select 'x' from pay_us_state_tax_info_f stif
where stif.state_code = pus.state_code
and stif.sta_information7 = 'Y'
and stif.sta_information9 is null
and pta.transaction_effective_date between
stif.effective_start_date and
stif.effective_end_date);
select meaning
from hr_lookups
where lookup_type = 'US_FIT_FILING_STATUS'
and lookup_code = lv_status_code;
select /*+ ordered */ prl.prl_information1 --Bug 3362223
from pay_stat_trans_audit pta
,per_assignments_f paf
,pay_payrolls_f prl
where prl.payroll_id = paf.payroll_id
and prl.prl_information_category = 'US'
and paf.assignment_id = pta.assignment_id
and pta.source4 = ln_transaction_id
and pta.source4_type = 'TRANSACTION_ID'
and pta.assignment_id = ln_current_assignment_id
-- and pta.transaction_parent_id is null
and pta.transaction_effective_date between prl.effective_start_date and
prl.effective_end_date
and pta.transaction_effective_date between paf.effective_start_date and
paf.effective_end_date
order by pta.assignment_id asc;
select org.org_information1
from hr_organization_information org
where org.org_information_context || '' = 'Contact Information'
and org.organization_id =
(select /*+ ordered */ hsc.segment1 --Bug 3362223
from pay_stat_trans_audit pta
,per_assignments_f paf
,hr_soft_coding_keyflex hsc
where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
and paf.assignment_id = pta.assignment_id
and pta.source4 = ln_transaction_id
and pta.source4_type = 'TRANSACTION_ID'
and pta.transaction_parent_id is null
and paf.assignment_id = ln_current_assignment_id
and pta.transaction_effective_date between paf.effective_start_date
and paf.effective_end_date);
select org.org_information1
from hr_organization_information org
,per_assignments_f paf
,pay_stat_trans_audit pta
,hr_soft_coding_keyflex hsc
where org.organization_id = hsc.segment1
and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
and paf.assignment_id = pta.assignment_id
and pta.source4 = ln_transaction_id
and pta.source4_type = 'TRANSACTION_ID'
and org.org_information_context = 'Contact Information'
and pta.assignment_id = ln_current_assignment_id
and pta.transaction_effective_date between paf.effective_start_date and
paf.effective_end_date
order by pta.assignment_id asc;
select /*+ ordered */ usr.employee_id --Bug 3362223
,pta.assignment_id
from pay_stat_trans_audit pta
,per_assignments_f paf
,pay_payrolls_f prl
,fnd_user usr
where prl.payroll_id = paf.payroll_id
and usr.user_name = prl.prl_information1
and prl.prl_information_category = 'US'
and paf.assignment_id = pta.assignment_id
and pta.source4 = ln_transaction_id
and pta.source4_type = 'TRANSACTION_ID'
and pta.assignment_id = ln_current_assignment_id
-- and pta.transaction_parent_id is null
and pta.transaction_effective_date between prl.effective_start_date and
prl.effective_end_date
and pta.transaction_effective_date between paf.effective_start_date and
paf.effective_end_date
order by pta.assignment_id asc;
select usr.employee_id
,pta.assignment_id
from hr_organization_information org
,pay_stat_trans_audit pta
,fnd_user usr
where usr.user_name = org.org_information1
and pta.assignment_id = ln_current_assignment_id
and pta.source4 = ln_transaction_id
and pta.source4_type = 'TRANSACTION_ID'
and pta.transaction_parent_id is null
and org.org_information_context ||'' = 'Contact Information'
and org.organization_id = (select hsc.segment1
from per_assignments_f paf
,hr_soft_coding_keyflex hsc
where paf.assignment_id = ln_current_assignment_id
and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
and pta.transaction_effective_date
between paf.effective_start_date
and paf.effective_end_date
);
select transaction_subtype
,business_group_id
,person_id
,assignment_id
,transaction_effective_date
,source1
,source1_type
,source2
,source2_type
,audit_information2
,audit_information4
from pay_stat_trans_audit
where source4_type = 'TRANSACTION_ID'
and source4 = ln_transaction_id;
select fed_information1
from pay_us_federal_tax_info_f
where fed_information_category = 'ALLOWANCES LIMIT'
and trunc(sysdate) between effective_start_date
and effective_end_date;