View: PAYBV_US_EMP_CT_TAX_RULES_F_V

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

View Text

SELECT PUECTR.EFFECTIVE_START_DATE
, PUECTR.EFFECTIVE_END_DATE
, PUECTR.STATE_CODE
, PUECTR.COUNTY_CODE
, PUECTR.CITY_CODE
, PUECTR.ADDITIONAL_WA_RATE
, PUECTR.FILING_STATUS_CODE
, PUECTR.JURISDICTION_CODE
, PUECTR.LIT_ADDITIONAL_TAX
, PUECTR.LIT_OVERRIDE_AMOUNT
, PUECTR.LIT_OVERRIDE_RATE
, PUECTR.WITHHOLDING_ALLOWANCES
, PUECTR.SCHOOL_DISTRICT_CODE /* CODES */
, PUECTR.LIT_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECTR.LIT_EXEMPT)
, PUECTR.SD_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECTR.SD_EXEMPT)
, PUECTR.HT_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECTR.HT_EXEMPT) /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:ADDITIONAL CITY TAX INFO:PUECTR'
, '_DF:PAY:FURTHER CITY TAX INFO:PUECTR' /* ID COLUMNS */
, PUECTR.EMP_CITY_TAX_RULE_ID
, PUECTR.BUSINESS_GROUP_ID
, PUECTR.ASSIGNMENT_ID /* WHO COLUMNS */
, PUECTR.LAST_UPDATE_DATE
, PUECTR.LAST_UPDATED_BY
, PUECTR.CREATED_BY
, PUECTR.CREATION_DATE
FROM PAY_US_EMP_CITY_TAX_RULES_F PUECTR
WHERE PUECTR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUECTR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns