View: PAY_US_W2_BOX14_BOONE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_W2_BOX14_BOONE_V

View Text

SELECT YEAR
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, ASSIGNMENT_ACTION_ID
, PAYROLL_ACTION_ID
, TAX_UNIT_ID
, W2_OTHER_MEANING W2_OTHER_CODE
, W2_OTHER_MEANING
, W2_OTHER_VALUE
, W2_OTHER_BAL_NAME
, SERIAL_NUMBER
, BUSINESS_GROUP_ID
FROM PAY_US_OTHER_W2_V UNION ALL SELECT YEAR
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, ASSIGNMENT_ACTION_ID
, PAYROLL_ACTION_ID
, TAX_UNIT_ID
, 'BOONOCC' W2_OTHER_CODE
, NULL
, W2_LOCAL_INCOME_TAX - DECODE(SIGN(W2_LOCAL_WAGES - CNTY_INFORMATION7)
, -1
, (W2_LOCAL_WAGES * (CNTY_INFORMATION3/100))
, CNTY_INFORMATION4) W2_OTHER_VALUE
, NULL
, SERIAL_NUMBER
, BUSINESS_GROUP_ID
FROM PAY_US_LOCALITY_W2_V PUL
, PAY_US_COUNTY_TAX_INFO_F PCT
WHERE PUL.STATE_ABBREV = 'KY'
AND PUL.TAX_TYPE = 'COUNTY'
AND SUBSTR(PUL.JURISDICTION
, 1
, 6) = '18-015'
AND PCT.JURISDICTION_CODE = '18-015-0000'
AND (TO_DATE('31-12-'||TO_CHAR(YEAR)
, 'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE) UNION ALL SELECT YEAR
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, ASSIGNMENT_ACTION_ID
, PAYROLL_ACTION_ID
, TAX_UNIT_ID
, 'BOONMH' W2_OTHER_CODE
, NULL
, DECODE(SIGN(W2_LOCAL_WAGES - CNTY_INFORMATION7)
, -1
, (W2_LOCAL_WAGES * (CNTY_INFORMATION3/100))
, CNTY_INFORMATION4) W2_OTHER_VALUE
, NULL
, SERIAL_NUMBER
, BUSINESS_GROUP_ID
FROM PAY_US_LOCALITY_W2_V PUL
, PAY_US_COUNTY_TAX_INFO_F PCT
WHERE PUL.STATE_ABBREV = 'KY'
AND PUL.TAX_TYPE = 'COUNTY'
AND SUBSTR(PUL.JURISDICTION
, 1
, 6) = '18-015'
AND PCT.JURISDICTION_CODE = '18-015-0000'
AND (TO_DATE('31-12-'||TO_CHAR(YEAR)
, 'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE)

Columns