[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 |