Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 11 May 2016

Employee tax info and fedral tax rules

select ppf.employee_number "employee number",
  (select state_name from pay_us_states where state_abbrev = add_information17
  ) "resident",
  (select hlat.region_2
  from hr_locations_all hlat
  where hlat.location_id = paaf.location_id
  ) "work",
  pus.state_name "sui state",
  paa.add_information18 "resident city",
  pus.state_name "work city",
  paa.add_information19 "resident county",
  (select hlat.region_1
  from hr_locations_all hlat
  where hlat.location_id = paaf.location_id
  ) "work county",
  hrl1.meaning "filing status",
  ftr.withholding_allowances "allowances",
  ftr.fit_additional_tax "additional tax",
  ftr.fit_exempt "tax exemption :fit",
  ftr.futa_tax_exempt "tax exemption :futa",
  ftr.medicare_tax_exempt "tax exemption :medicare",
  ftr.ss_tax_exempt "tax exemption :ss",
  ftr.fit_override_amount "fo:regular amount",
  ftr.fit_override_rate "fo:regular rate",
  ftr.supp_tax_override_rate "fo:supplemental rate",
  ftr.excessive_wa_reject_date "lock in date",
  ftr.statutory_employee "statutory employee",
  ftr.cumulative_taxation "cumulative taxation",
  ftr.wage_exempt "fit exempt wage acc",
  hrl2.meaning "eic filling status",
  ftr.effective_start_date "effec dates: from",
  decode (ftr.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, ftr.effective_end_date ) "effec dates: to",
  ftr.emp_fed_tax_rule_id,
  paaf.assignment_id,
  paaf.location_id
from pay_us_emp_fed_tax_rul ftr,
  per_all_assignments_f paaf,
  pay_us_states pus,
  per_addresses paa,
  hr_lookups hrl1,
  hr_lookups hrl2,
  per_all_people_f ppf
where 1=1
and ftr.sui_state_code         = pus.state_code
and ftr.assignment_id          = paaf.assignment_id
and paa.person_id              = paaf.person_id
and ftr.filing_status_code     = hrl1.lookup_code
and hrl1.lookup_type           = 'us_fit_filing_status'
and ftr.eic_filing_status_code = hrl2.lookup_code
and hrl2.lookup_type           = 'us_eic_filing_status'
  --     and nvl (paaf.effective_end_date, sysdate) > sysdate - 1
and ftr.assignment_id   = paaf.assignment_id
and paaf.person_id      = ppf.person_id
---and ppf.employee_number = '30987'
--and paaf.assignment_number   = '471-96-6472'
group by ppf.employee_number,
  pus.state_name,
  paa.add_information18,
  pus.state_name,
  add_information17,
  paa.add_information19,
  hrl1.meaning,
  ftr.withholding_allowances,
  ftr.fit_additional_tax,
  ftr.fit_exempt,
  ftr.futa_tax_exempt,
  ftr.medicare_tax_exempt,
  ftr.ss_tax_exempt,
  ftr.fit_override_amount,
  ftr.fit_override_rate,
  ftr.supp_tax_override_rate,
  ftr.excessive_wa_reject_date,
  ftr.statutory_employee,
  ftr.cumulative_taxation,
  ftr.wage_exempt,
  hrl2.meaning,
  ftr.effective_start_date,
  decode (ftr.effective_end_date, to_date ('31124712', 'ddmmyyyy'), null, ftr.effective_end_date ),
  ftr.emp_fed_tax_rule_id,
  paaf.assignment_id,
  paaf.location_id
order by 1,

  2;   
Share this article :

4 comments:

  1. I'm certainly very happy to read this blog site posts which carries plenty of helpful data, thanks for providing such information. Visit this website

    ReplyDelete
  2. Medicare's commencement in 1965. Nancy considered dropping Part B since it has a monthbuy modvigil in usa

    ReplyDelete
  3. Oracle 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.

    ReplyDelete
  4. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! current interest rate in pakistan | ubl saving account

    ReplyDelete