FND Design Data [Home] [Help]

View: PAYBV_STATE_RULES_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAYBV_STATE_RULES_V
View Text

SELECT PSR.STATE_CODE
, PSR.FIPS_CODE
, PSR.JURISDICTION_CODE
, PSR.NAME
, PSR.HEAD_TAX_PERIOD
, PSR.WC_EXECUTIVE_WEEKLY_MAX
, PSR.FS_LOOKUP_TYPE /* CODES */
, PSR.WC_OVERTIME_HOURS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PSR.WC_OVERTIME_HOURS) /* WHO COLUMNS */
, PSR.LAST_UPDATE_DATE
, PSR.LAST_UPDATED_BY
, PSR.CREATED_BY
, PSR.CREATION_DATE
FROM PAY_STATE_RULES PSR WITH READ ONLY

Columns

Name
STATE_ABBREV
FIPS_CODE
JURISDICTION_CODE
NAME
HEAD_TAX_PERIOD
WC_EXECUTIVE_WEEKLY_MAX
FS_LOOKUP_TYPE
WC_OVERTIME_HOURS_FLAG
WC_OVERTIME_HOURS
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE