VIEW: APPS.PAY_US_W2_BOX14_BOONE_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)