DBA Data[Home] [Help]

VIEW: APPS.PAYBV_US_FEDERAL_TAX_INFO_F_V

Source

View Text - Preformatted

SELECT PUFTI.EFFECTIVE_START_DATE ,PUFTI.EFFECTIVE_END_DATE ,PUFTI.FUTA_WAGE_LIMIT ,PUFTI.FUTA_RATE ,PUFTI.SS_EE_WAGE_LIMIT ,PUFTI.SS_EE_RATE ,PUFTI.SS_ER_WAGE_LIMIT ,PUFTI.SS_ER_RATE ,PUFTI.MEDI_EE_RATE ,PUFTI.MEDI_ER_RATE ,PUFTI.PROGRAM_UPDATE_DATE /* descriptive flexfield */ ,'_DF:PAY:Federal Tax Rate Info DF:PUFTI' /* id columns */ ,FEDERAL_TAX_INFO_ID ,REQUEST_ID ,PROGRAM_APPLICATION_ID ,PROGRAM_ID /* who columns */ ,PUFTI.LAST_UPDATE_DATE ,PUFTI.LAST_UPDATED_BY ,PUFTI.CREATED_BY ,PUFTI.CREATION_DATE FROM PAY_US_FEDERAL_TAX_INFO_F PUFTI WITH READ ONLY
View Text - HTML Formatted

SELECT PUFTI.EFFECTIVE_START_DATE
, PUFTI.EFFECTIVE_END_DATE
, PUFTI.FUTA_WAGE_LIMIT
, PUFTI.FUTA_RATE
, PUFTI.SS_EE_WAGE_LIMIT
, PUFTI.SS_EE_RATE
, PUFTI.SS_ER_WAGE_LIMIT
, PUFTI.SS_ER_RATE
, PUFTI.MEDI_EE_RATE
, PUFTI.MEDI_ER_RATE
, PUFTI.PROGRAM_UPDATE_DATE /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:FEDERAL TAX RATE INFO DF:PUFTI' /* ID COLUMNS */
, FEDERAL_TAX_INFO_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID /* WHO COLUMNS */
, PUFTI.LAST_UPDATE_DATE
, PUFTI.LAST_UPDATED_BY
, PUFTI.CREATED_BY
, PUFTI.CREATION_DATE
FROM PAY_US_FEDERAL_TAX_INFO_F PUFTI WITH READ ONLY