[Home] [Help]
View: PAYBV_US_TAX_BALANCES_V
View Text
SELECT PUTB.EE_OR_ER_CODE
, PUTB.USER_REPORTING_NAME /* CODES */
, PUTB.BALANCE_CATEGORY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('US_TAX_BALANCE_CATEGORY'
, PUTB.BALANCE_CATEGORY_CODE) /* ID COLUMNS */
, PUTB.TAX_BALANCE_ID
, PUTB.TAX_TYPE_ID
, PUTB.BALANCE_TYPE_ID
FROM PAY_US_TAX_BALANCES PUTB WITH READ ONLY
Columns
| Name |
| EE_OR_ER_CODE |
| USER_REPORTING_NAME |
| BALANCE_CATEGORY_CODE |
| BALANCE_CATEGORY |
| TAX_BALANCE_ID |
| TAX_TYPE_ID |
| BALANCE_TYPE_ID |