DBA Data[Home] [Help]

VIEW: APPS.PAYBV_STATE_RULES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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