Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_COUNTY_TAX_INFO_F_V |
SELECT PUCNTI.EFFECTIVE_START_DATE
, PUCNTI.EFFECTIVE_END_DATE
, PUCNTI.JURISDICTION_CODE
, PUCNTI.PROGRAM_UPDATE_DATE /* CODES */
, PUCNTI.COUNTY_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCNTI.COUNTY_TAX)
, PUCNTI.HEAD_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCNTI.HEAD_TAX)
, PUCNTI.SCHOOL_TAX
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUCNTI.SCHOOL_TAX) /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:COUNTY TAX STATUS INFO:PUCNTI' /* ID COLUMNS */
, PUCNTI.COUNTY_TAX_INFO_ID
, PUCNTI.REQUEST_ID
, PUCNTI.PROGRAM_APPLICATION_ID
, PUCNTI.PROGRAM_ID /* WHO COLUMNS */
, PUCNTI.LAST_UPDATE_DATE
, PUCNTI.LAST_UPDATED_BY
, PUCNTI.CREATED_BY
, PUCNTI.CREATION_DATE
FROM PAY_US_COUNTY_TAX_INFO_F PUCNTI WITH READ ONLY