VIEW: APPS.PAYBV_US_CITY_TAX_INFO_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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