Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US federal tax rules |
Implementation/DBA Data: | APPS.HR_H2PI_FEDERAL_TAX_RULES_V |
SELECT ASG.PERSON_ID
, FED.EMP_FED_TAX_RULE_ID
, FED.EFFECTIVE_START_DATE
, FED.EFFECTIVE_END_DATE
, FED.ASSIGNMENT_ID
, FED.SUI_STATE_CODE
, FED.SUI_JURISDICTION_CODE
, FED.BUSINESS_GROUP_ID
, FED.ADDITIONAL_WA_AMOUNT
, FED.FILING_STATUS_CODE
, FED.FIT_OVERRIDE_AMOUNT
, FED.FIT_OVERRIDE_RATE
, FED.WITHHOLDING_ALLOWANCES
, FED.CUMULATIVE_TAXATION
, FED.EIC_FILING_STATUS_CODE
, FED.FIT_ADDITIONAL_TAX
, FED.FIT_EXEMPT
, FED.FUTA_TAX_EXEMPT
, FED.MEDICARE_TAX_EXEMPT
, FED.SS_TAX_EXEMPT
, FED.STATUTORY_EMPLOYEE
, FED.W2_FILED_YEAR
, FED.SUPP_TAX_OVERRIDE_RATE
, FED.EXCESSIVE_WA_REJECT_DATE
, FED.LAST_UPDATE_DATE
, FED.OBJECT_VERSION_NUMBER
FROM PAY_US_EMP_FED_TAX_RULES_F FED
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE FED.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND FED.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE