View: PAYBV_US_EMP_FED_TAX_RULES_F_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_US_EMP_FED_TAX_RULES_F_V

View Text

SELECT PUEFTR.EFFECTIVE_START_DATE
, PUEFTR.EFFECTIVE_END_DATE
, PUEFTR.SUI_STATE_CODE
, PUEFTR.SUI_JURISDICTION_CODE
, PUEFTR.ADDITIONAL_WA_AMOUNT
, PUEFTR.FILING_STATUS_CODE
, PUEFTR.FIT_OVERRIDE_AMOUNT
, PUEFTR.FIT_OVERRIDE_RATE
, PUEFTR.WITHHOLDING_ALLOWANCES
, PUEFTR.EIC_FILING_STATUS_CODE
, PUEFTR.FIT_ADDITIONAL_TAX
, PUEFTR.W2_FILED_YEAR
, PUEFTR.SUPP_TAX_OVERRIDE_RATE
, PUEFTR.EXCESSIVE_WA_REJECT_DATE /* CODES */
, PUEFTR.CUMULATIVE_TAXATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.CUMULATIVE_TAXATION)
, PUEFTR.FIT_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.FIT_EXEMPT)
, PUEFTR.FUTA_TAX_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.FUTA_TAX_EXEMPT)
, PUEFTR.MEDICARE_TAX_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.MEDICARE_TAX_EXEMPT)
, PUEFTR.SS_TAX_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.SS_TAX_EXEMPT)
, PUEFTR.STATUTORY_EMPLOYEE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUEFTR.STATUTORY_EMPLOYEE) /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:ADDITIONAL FEDERAL TAX INFO:PUEFTR'
, '_DF:PAY:FURTHER FEDERAL TAX INFO:PUEFTR' /* ID COLUMNS */
, PUEFTR.EMP_FED_TAX_RULE_ID
, PUEFTR.BUSINESS_GROUP_ID
, PUEFTR.ASSIGNMENT_ID /* WHO COLUMNS */
, PUEFTR.LAST_UPDATE_DATE
, PUEFTR.LAST_UPDATED_BY
, PUEFTR.CREATED_BY
, PUEFTR.CREATION_DATE
FROM PAY_US_EMP_FED_TAX_RULES_F PUEFTR
WHERE PUEFTR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUEFTR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns