FND Design Data [Home] [Help]

View: PAYBV_US_SC_DSTS_TAX_INFO_F_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAYBV_US_SC_DSTS_TAX_INFO_F_V
View Text

SELECT PUSDTI.EFFECTIVE_START_DATE
, PUSDTI.EFFECTIVE_END_DATE
, PUSDTI.STATE_CODE
, PUSDTI.SCHOOL_DSTS_CODE
, PUSDTI.JURISDICTION_CODE
, PUSDTI.PROGRAM_UPDATE_DATE /* ID COLUMNS */
, SCHOOL_TAX_INFO_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID /* WHO COLUMNS */
, PUSDTI.LAST_UPDATE_DATE
, PUSDTI.LAST_UPDATED_BY
, PUSDTI.CREATED_BY
, PUSDTI.CREATION_DATE
FROM PAY_US_SCHOOL_DSTS_TAX_INFO_F PUSDTI WITH READ ONLY

Columns

Name
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
STATE_CODE
SCHOOL_DSTS_CODE
JURISDICTION_CODE
PROGRAM_UPDATE_DATE
SCHOOL_TAX_INFO_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE