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
ReplyDeleteGreat Article, Helps me a lot. Would be thank full to you if in feature you share this kind of awesome and informative articles. CarHelpline:RoadSide Assistance Pakistan
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
ReplyDelete