VIEW: APPS.HR_H2PI_STATE_TAX_RULES_V

Source

View Text - Preformatted

SELECT asg.person_id, sta.emp_state_tax_rule_id, sta.effective_start_date, sta.effective_end_date, sta.assignment_id, sta.state_code, sta.jurisdiction_code, sta.business_group_id, sta.additional_wa_amount, sta.filing_status_code, sta.remainder_percent, sta.secondary_wa, sta.sit_additional_tax, sta.sit_override_amount, sta.sit_override_rate, sta.withholding_allowances, sta.excessive_wa_reject_date, sta.sdi_exempt, sta.sit_exempt, sta.sit_optional_calc_ind, sta.state_non_resident_cert, sta.sui_exempt, sta.wc_exempt, sta.sui_wage_base_override_amount, sta.supp_tax_override_rate, sta.last_update_date, sta.object_version_number from pay_us_emp_state_tax_rules_f sta, hr_h2pi_assignments_v asg WHERE sta.assignment_id = asg.assignment_id and sta.effective_start_date between asg.effective_start_date and asg.effective_end_date

View Text - HTML Formatted

SELECT ASG.PERSON_ID
, STA.EMP_STATE_TAX_RULE_ID
, STA.EFFECTIVE_START_DATE
, STA.EFFECTIVE_END_DATE
, STA.ASSIGNMENT_ID
, STA.STATE_CODE
, STA.JURISDICTION_CODE
, STA.BUSINESS_GROUP_ID
, STA.ADDITIONAL_WA_AMOUNT
, STA.FILING_STATUS_CODE
, STA.REMAINDER_PERCENT
, STA.SECONDARY_WA
, STA.SIT_ADDITIONAL_TAX
, STA.SIT_OVERRIDE_AMOUNT
, STA.SIT_OVERRIDE_RATE
, STA.WITHHOLDING_ALLOWANCES
, STA.EXCESSIVE_WA_REJECT_DATE
, STA.SDI_EXEMPT
, STA.SIT_EXEMPT
, STA.SIT_OPTIONAL_CALC_IND
, STA.STATE_NON_RESIDENT_CERT
, STA.SUI_EXEMPT
, STA.WC_EXEMPT
, STA.SUI_WAGE_BASE_OVERRIDE_AMOUNT
, STA.SUPP_TAX_OVERRIDE_RATE
, STA.LAST_UPDATE_DATE
, STA.OBJECT_VERSION_NUMBER
FROM PAY_US_EMP_STATE_TAX_RULES_F STA
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE STA.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND STA.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE