select ppf.employee_number "employee number",
hrl.lookup_type,
--pus.state_name "state",
hrl.meaning "w4 info :filing status",
str.withholding_allowances "w4 info :allowances",
str.secondary_wa "w4 info: secon allowances",
str.additional_wa_amount "w4 info:exemption aaount",
str.sit_additional_tax "w4 info:addn tax",
str.sit_optional_calc_ind "w4 info :opt calc",
str.sit_exempt "tax ex: sit",
str.sdi_exempt "tax ex: sdi",
str.sui_exempt "tax ex: sui",
str.wc_exempt "tax ex: wc",
str.sit_override_rate "sit override:regular rate",
str.sit_override_amount "sit override:regular amount",
str.supp_tax_override_rate "sit override: supp rate",
str.sui_wage_base_override_amount "sui base override",
str.excessive_wa_reject_date "lock in date",
str.state_non_resident_cert "non resi certi",
str.wage_exempt "sit exm fm wg accm",
str.effective_start_date "effective date : from",
decode (str.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, str.effective_end_date ) "effective date: to",
str.assignment_id,
str.business_group_id
from pay_us_emp_state_tax_rul str,
pay_us_states pus,
pay_state_rules psr,
hr_lookups hrl,
per_all_assignments_f paaf,
per_all_people_f ppf
where 1 =1
and str.state_code=pus.state_code
and psr.state_code = pus.state_abbrev
and hrl.lookup_type = psr.fs_lookup_type
and sysdate between paaf.effective_start_date and paaf.effective_end_date
and nvl (str.effective_end_date, sysdate) > sysdate - 1
and hrl.lookup_code = ltrim (str.filing_status_code, '0')
and str.assignment_id = paaf.assignment_id
and nvl (paaf.effective_end_date, sysdate) > sysdate - 1
and paaf.person_id = ppf.person_id
--and ppf.employee_number = '30987'
--and paaf.assignment_number = '471-96-6472'
group by ppf.employee_number,
hrl.lookup_type,
pus.state_name,pus.state_code,
hrl.meaning,psr.state_code , pus.state_abbrev,
str.withholding_allowances,
str.secondary_wa,
str.additional_wa_amount,
str.sit_additional_tax,
str.sit_optional_calc_ind,
str.sit_exempt,
str.sdi_exempt,
str.sui_exempt,
str.wc_exempt,
str.sit_override_rate,
str.sit_override_amount,
str.supp_tax_override_rate,
str.sui_wage_base_override_amount,
str.excessive_wa_reject_date,
str.state_non_resident_cert,
str.wage_exempt,
str.effective_start_date,
decode (str.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, str.effective_end_date ),
str.assignment_id,
str.business_group_id;
It is extremely nice to see the greatest details presented in an easy and understanding manner. meezan bank car financing calculator - bank alfalah car loan
ReplyDeleteThis is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work global tax information
ReplyDeleteThe exception is applied on the principal $100K taxable salary and requires the organization to meet the accompanying conditionshow to reduce tax singapore
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDeleteThe initial step requires the Fiduciary to record IRS Form 4506, Request for Copy or Transcript of Tax Form, with the IRS.Verfahrensdokumentation Muster
ReplyDeleteThis was really an interesting topic and I kinda agree with what you have mentioned here! Tax
ReplyDeleteI’ve been searching for some decent stuff on the subject and haven't had any luck up until this point, You just got a new biggest fan!.. Restaurant Payroll Tax Problems
ReplyDeletevery interesting keep posting. ettevõtte kustutamine
ReplyDeleteThis is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here! ettevõtte kustutamine
ReplyDeleteCalif estimated tax payments Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though.
ReplyDeleteThis is because they do not realize that they can opt for the cheap and not the expensive one. cheap car insurance az
ReplyDeleteI like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... tax service providers
ReplyDeleteIt was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. orland park real estate agents
ReplyDeleteInteresting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks wimbledon tax accountants
ReplyDeleteFiling return happened to be a cumbersome task earlier. But , with passage of time, government has simplified the procedure up to a great extent by introducing the process of filing online income tax return. visit this link
ReplyDeleteEach of these activities in its own right involves some form of tax advice and each professional can be regarded as a "tax professional", each of which, play a very important part in ensuring that our tax administration and systems work.IR35 Limited Company registration
ReplyDeleteWithholding and reciprocity laws vary per state. See Calculation Guide for the United States Vertex Payroll Tax Q Series for more details on each state's standard operating procedure. The resident wage accumulation rules that are accessible to you are determined by these tax withholding regulations. The default tax withholding information for the payroll process is provided by the federal and state withholding forms.
ReplyDeletetax accounting