eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HR_H2PI_STATE_TAX_RULES_V

Product:	PER - Human Resources
Description:	Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US state tax rules
Implementation/DBA Data:	APPS.HR_H2PI_STATE_TAX_RULES_V

View Text

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

Columns

Name
PERSON_ID
EMP_STATE_TAX_RULE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ASSIGNMENT_ID
STATE_CODE
JURISDICTION_CODE
BUSINESS_GROUP_ID
ADDITIONAL_WA_AMOUNT
FILING_STATUS_CODE
REMAINDER_PERCENT
SECONDARY_WA
SIT_ADDITIONAL_TAX
SIT_OVERRIDE_AMOUNT
SIT_OVERRIDE_RATE
WITHHOLDING_ALLOWANCES
EXCESSIVE_WA_REJECT_DATE
SDI_EXEMPT
SIT_EXEMPT
SIT_OPTIONAL_CALC_IND
STATE_NON_RESIDENT_CERT
SUI_EXEMPT
WC_EXEMPT
SUI_WAGE_BASE_OVERRIDE_AMOUNT
SUPP_TAX_OVERRIDE_RATE
LAST_UPD_DATE
OBJECT_VERSION_NUMBER