Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_CITY_TAX_INFO_F_V |
SELECT PUCTI.EFFECTIVE_START_DATE
, PUCTI.EFFECTIVE_END_DATE
, PUCTI.JURISDICTION_CODE
, PUCTI.PROGRAM_UPDATE_DATE /* CODES */
, PUCTI.CITY_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCTI.CITY_TAX)
, PUCTI.HEAD_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCTI.HEAD_TAX)
, PUCTI.SCHOOL_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCTI.SCHOOL_TAX) /* ID COLUMNS */
, PUCTI.CITY_TAX_INFO_ID
, PUCTI.REQUEST_ID
, PUCTI.PROGRAM_APPLICATION_ID
, PUCTI.PROGRAM_ID /* WHO COLUMNS */
, PUCTI.LAST_UPDATE_DATE
, PUCTI.LAST_UPDATED_BY
, PUCTI.CREATED_BY
, PUCTI.CREATION_DATE
FROM PAY_US_CITY_TAX_INFO_F PUCTI WITH READ ONLY