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