View: PAY_US_COUNTY_TAX_BAL_GRE_V

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

View Text

SELECT BAL.BALANCE_SET_NAME BALANCE_SET_NAME
, BAL.LEGISLATION_CODE LEGISLATION_CODE
, BAL.ATTRIBUTE_1 BALANCE_NAME
, BAL.ATTRIBUTE_2 TAX_CLASSIFICATION
, BAL.ATTRIBUTE_3 WAGES_CLASSIFICATION
, BAL.ATTRIBUTE_4 DIMENSION
, BAL.ATTRIBUTE_5 REPORTING_NAME
, ST.STATE_ABBREV STATE_ABBREV
, ST.STATE_CODE STATE_CODE
, CN.COUNTY_NAME COUNTY_NAME
, CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000' COUNTY_JD
, TAX.TAX_UNIT_ID GRE_ID
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000'
, -1
, NULL
, NULL
, NULL) CTD_TAX_VALUE
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000'
, -1
, NULL
, NULL
, NULL) CTD_WAGE_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000'
, -1
, NULL
, NULL
, NULL)) OTD_TAX_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000'
, -1
, NULL
, NULL
, NULL)) OTD_WAGE_VALUE
FROM PAY_US_COUNTIES CN
, PAY_US_STATES ST
, PAY_BALANCE_SETS BAL
, PAY_US_TAX_UNIT_COUNTIES_V TAX
WHERE CN.STATE_CODE = ST.STATE_CODE
AND BAL.BALANCE_SET_NAME LIKE 'COUNTY_TRR%'AND SUBSTR(TAX.JURISDICTION_CODE
, 1
, 2) = CN.STATE_CODE
AND SUBSTR(TAX.JURISDICTION_CODE
, 4
, 3) = CN.COUNTY_CODE
AND SUBSTR(TAX.JURISDICTION_CODE
, 8
, 4) = '0000'
AND PAY_US_PAYROLL_UTILS.GET_TAX_EXISTS(CN.STATE_CODE||'-'||CN.COUNTY_CODE||'-0000'
, BAL.ATTRIBUTE_1) = 'Y'

Columns