Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US City Tax Rules |
Implementation/DBA Data: | APPS.HR_H2PI_CITY_TAX_RULES_V |
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