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_COUNTY_TAX_RULES_V

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

View Text

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

Columns

Name
PERSON_ID
EMP_COUNTY_TAX_RULE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ASSIGNMENT_ID
STATE_CODE
COUNTY_CODE
BUSINESS_GROUP_ID
ADDITIONAL_WA_RATE
FILING_STATUS_CODE
JURISDICTION_CODE
LIT_ADDITIONAL_TAX
LIT_OVERRIDE_AMOUNT
LIT_OVERRIDE_RATE
WITHHOLDING_ALLOWANCES
LIT_EXEMPT
SD_EXEMPT
HT_EXEMPT
SCHOOL_DISTRICT_CODE
LAST_UPD_DATE
OBJECT_VERSION_NUMBER