VIEW: APPS.PAY_US_STATE_TAX_BAL_GRE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'