View: PAY_US_FEDERAL_TAX_BAL_GRE_V

Product:	PAY - Payroll
Description:	- Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.PAY_US_FEDERAL_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.ORGANIZATION_ID D_TAX_UNIT_ID
, TAX.NAME D_NAME
, 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.ORGANIZATION_ID
, '00-000-0000'
, -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.ORGANIZATION_ID
, '00-000-0000'
, -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.ORGANIZATION_ID
, '00-000-0000'
, -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.ORGANIZATION_ID
, '00-000-0000'
, -1
, NULL
, NULL
, NULL))) D_WAGE_OTD_VALUE
FROM PAY_BALANCE_SETS BAL
, HR_ALL_ORGANIZATION_UNITS TAX
, HR_ORGANIZATION_INFORMATION OGI
WHERE OGI.ORGANIZATION_ID = TAX.ORGANIZATION_ID
AND OGI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OGI.ORG_INFORMATION1 = 'HR_LEGAL'
AND BAL.LEGISLATION_CODE = 'US'

Columns