The following lines contain the word 'select', 'insert', 'update' or 'delete':
select min(fed.effective_start_date)
from pay_us_emp_fed_tax_rules_f fed
where fed.assignment_id = p_assignment_id;
select null
from pay_us_emp_state_tax_rules_f sta
where sta.assignment_id = p_assignment_id
and sta.state_code = p_state_code;
select asg.business_group_id
from per_assignments_f asg
where asg.assignment_id = p_assignment_id
and l_effective_date between asg.effective_start_date
and asg.effective_end_date;
select psr.jurisdiction_code
from pay_state_rules psr, pay_us_states pus
where pus.state_code = p_state_code
and pus.state_abbrev = psr.state_code;
select hrl.lookup_code, peft.withholding_allowances
from HR_LOOKUPS hrl
, PAY_US_EMP_FED_TAX_RULES_V peft
where hrl.lookup_type = 'US_FS_'||p_state_code
and upper(hrl.meaning) = decode(
upper(substr(peft.filing_status,1,7)),
'MARRIED',
'MARRIED',
upper(peft.filing_status))
and peft.assignment_id = p_assignment_id ;
select flv.lookup_code, peft.withholding_allowances
from FND_LOOKUP_VALUES flv
, PAY_US_EMP_FED_TAX_RULES_V peft
where flv.lookup_type = 'US_FS_'||p_state_code
and upper(flv.meaning) = decode(
upper(substr(peft.filing_status,1,7)),
'MARRIED',
'MARRIED',
upper(peft.filing_status))
and peft.assignment_id = p_assignment_id
and flv.language = 'US'
and flv.enabled_flag='Y';
select hoi.org_information12
from PAY_US_STATES pus,
HR_ORGANIZATION_INFORMATION hoi,
PER_ASSIGNMENTS_F paf,
HR_SOFT_CODING_KEYFLEX hsck
where paf.assignment_id = p_assignment_id
and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
and hoi.organization_id = hsck.segment1
and hoi.org_information_context = 'State Tax Rules'
and hoi.org_information1 = pus.state_abbrev
and pus.state_code = p_state_code;
,p_datetrack_mode => 'INSERT'
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_calculate_pct => FALSE
);
procedure update_state_tax_rule
(
p_validate in boolean default false
,p_effective_date in date
,p_datetrack_update_mode in varchar2
,p_emp_state_tax_rule_id in number
,p_object_version_number in out nocopy number
,p_additional_wa_amount in number default hr_api.g_number
,p_filing_status_code in varchar2 default hr_api.g_varchar2
,p_remainder_percent in number default hr_api.g_number
,p_secondary_wa in number default hr_api.g_number
,p_sit_additional_tax in number default hr_api.g_number
,p_sit_override_amount in number default hr_api.g_number
,p_sit_override_rate in number default hr_api.g_number
,p_withholding_allowances in number default hr_api.g_number
,p_excessive_wa_reject_date in date default hr_api.g_date
,p_sdi_exempt in varchar2 default hr_api.g_varchar2
,p_sit_exempt in varchar2 default hr_api.g_varchar2
,p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2
,p_state_non_resident_cert in varchar2 default hr_api.g_varchar2
,p_sui_exempt in varchar2 default hr_api.g_varchar2
,p_wc_exempt in varchar2 default hr_api.g_varchar2
,p_wage_exempt in varchar2 default hr_api.g_varchar2
,p_sui_wage_base_override_amoun in number default hr_api.g_number
,p_supp_tax_override_rate in number default hr_api.g_number
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_attribute21 in varchar2 default hr_api.g_varchar2
,p_attribute22 in varchar2 default hr_api.g_varchar2
,p_attribute23 in varchar2 default hr_api.g_varchar2
,p_attribute24 in varchar2 default hr_api.g_varchar2
,p_attribute25 in varchar2 default hr_api.g_varchar2
,p_attribute26 in varchar2 default hr_api.g_varchar2
,p_attribute27 in varchar2 default hr_api.g_varchar2
,p_attribute28 in varchar2 default hr_api.g_varchar2
,p_attribute29 in varchar2 default hr_api.g_varchar2
,p_attribute30 in varchar2 default hr_api.g_varchar2
,p_sta_information_category in varchar2 default hr_api.g_varchar2
,p_sta_information1 in varchar2 default hr_api.g_varchar2
,p_sta_information2 in varchar2 default hr_api.g_varchar2
,p_sta_information3 in varchar2 default hr_api.g_varchar2
,p_sta_information4 in varchar2 default hr_api.g_varchar2
,p_sta_information5 in varchar2 default hr_api.g_varchar2
,p_sta_information6 in varchar2 default hr_api.g_varchar2
,p_sta_information7 in varchar2 default hr_api.g_varchar2
,p_sta_information8 in varchar2 default hr_api.g_varchar2
,p_sta_information9 in varchar2 default hr_api.g_varchar2
,p_sta_information10 in varchar2 default hr_api.g_varchar2
,p_sta_information11 in varchar2 default hr_api.g_varchar2
,p_sta_information12 in varchar2 default hr_api.g_varchar2
,p_sta_information13 in varchar2 default hr_api.g_varchar2
,p_sta_information14 in varchar2 default hr_api.g_varchar2
,p_sta_information15 in varchar2 default hr_api.g_varchar2
,p_sta_information16 in varchar2 default hr_api.g_varchar2
,p_sta_information17 in varchar2 default hr_api.g_varchar2
,p_sta_information18 in varchar2 default hr_api.g_varchar2
,p_sta_information19 in varchar2 default hr_api.g_varchar2
,p_sta_information20 in varchar2 default hr_api.g_varchar2
,p_sta_information21 in varchar2 default hr_api.g_varchar2
,p_sta_information22 in varchar2 default hr_api.g_varchar2
,p_sta_information23 in varchar2 default hr_api.g_varchar2
,p_sta_information24 in varchar2 default hr_api.g_varchar2
,p_sta_information25 in varchar2 default hr_api.g_varchar2
,p_sta_information26 in varchar2 default hr_api.g_varchar2
,p_sta_information27 in varchar2 default hr_api.g_varchar2
,p_sta_information28 in varchar2 default hr_api.g_varchar2
,p_sta_information29 in varchar2 default hr_api.g_varchar2
,p_sta_information30 in varchar2 default hr_api.g_varchar2
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_state_tax_rule';
savepoint update_state_tax_rule;
,p_datetrack_mode => p_datetrack_update_mode
);
ROLLBACK TO update_state_tax_rule;
ROLLBACK TO update_state_tax_rule;
end update_state_tax_rule;