View: PAY_US_STATE_TAX_BAL_GRE_V

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

View Text

SELECT BAL.BALANCE_SET_NAME D_BALANCE_SET_NAME
, BAL.LEGISLATION_CODE D_LEGISLATION_CODE
, BAL.ATTRIBUTE_1 D_TAX_TYPE
, BAL.ATTRIBUTE_2 D_TAX_CLASSIFICATION
, BAL.ATTRIBUTE_3 D_WAGE_CLASSIFICATION
, BAL.ATTRIBUTE_5 D_REPORTING_NAME
, BAL.ATTRIBUTE_6 D_EE_OR_ER
, BAL.ATTRIBUTE_7 D_FORMAT_CODE
, BAL.ATTRIBUTE_4 D_DIMENSION
, TAX.TAX_UNIT_ID D_TAX_UNIT_ID
, TAX.STATE_CODE D_STATE_CODE
, DECODE(BAL.ATTRIBUTE_8
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, BAL.ATTRIBUTE_6
, BAL.ATTRIBUTE_8
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.STATE_CODE
, -1
, NULL
, NULL
, NULL)) D_TAX_CTD_VALUE
, DECODE(BAL.ATTRIBUTE_8
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, BAL.ATTRIBUTE_6
, BAL.ATTRIBUTE_8
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.STATE_CODE
, -1
, NULL
, NULL
, NULL)) D_WAGE_CTD_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, DECODE(BAL.ATTRIBUTE_2
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, BAL.ATTRIBUTE_6
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.STATE_CODE
, -1
, NULL
, NULL
, NULL))) D_TAX_OTD_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, DECODE(BAL.ATTRIBUTE_3
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, BAL.ATTRIBUTE_6
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.STATE_CODE
, -1
, NULL
, NULL
, NULL))) D_WAGE_OTD_VALUE
FROM PAY_US_TAX_UNIT_STATES_V TAX
, PAY_BALANCE_SETS BAL
WHERE PAY_US_PAYROLL_UTILS.GET_TAX_EXISTS(TAX.STATE_CODE
, BAL.ATTRIBUTE_1||' ' ||BAL.ATTRIBUTE_6) = 'Y'
AND BAL.LEGISLATION_CODE = 'US'

Columns