DBA Data[Home] [Help]

VIEW: APPS.PAYBV_US_TAX_BALANCES_V

Source

View Text - Preformatted

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

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