VIEW: APPS.HR_H2PI_CITY_TAX_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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