VIEW: APPS.HR_H2PI_COUNTY_TAX_RULES_V

Source

View Text - Preformatted

SELECT asg.person_id, cou.emp_county_tax_rule_id, cou.effective_start_date, cou.effective_end_date, cou.assignment_id, cou.state_code, cou.county_code, cou.business_group_id, cou.additional_wa_rate, cou.filing_status_code, cou.jurisdiction_code, cou.lit_additional_tax, cou.lit_override_amount, cou.lit_override_rate, cou.withholding_allowances, cou.lit_exempt, cou.sd_exempt, cou.ht_exempt, cou.school_district_code, cou.last_update_date, cou.object_version_number from pay_us_emp_county_tax_rules_f cou, hr_h2pi_assignments_v asg WHERE cou.assignment_id = asg.assignment_id and cou.effective_start_date between asg.effective_start_date and asg.effective_end_date

View Text - HTML Formatted

SELECT ASG.PERSON_ID
, COU.EMP_COUNTY_TAX_RULE_ID
, COU.EFFECTIVE_START_DATE
, COU.EFFECTIVE_END_DATE
, COU.ASSIGNMENT_ID
, COU.STATE_CODE
, COU.COUNTY_CODE
, COU.BUSINESS_GROUP_ID
, COU.ADDITIONAL_WA_RATE
, COU.FILING_STATUS_CODE
, COU.JURISDICTION_CODE
, COU.LIT_ADDITIONAL_TAX
, COU.LIT_OVERRIDE_AMOUNT
, COU.LIT_OVERRIDE_RATE
, COU.WITHHOLDING_ALLOWANCES
, COU.LIT_EXEMPT
, COU.SD_EXEMPT
, COU.HT_EXEMPT
, COU.SCHOOL_DISTRICT_CODE
, COU.LAST_UPDATE_DATE
, COU.OBJECT_VERSION_NUMBER
FROM PAY_US_EMP_COUNTY_TAX_RULES_F COU
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE COU.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND COU.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE