VIEW: APPS.PAY_US_FEDERAL_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.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'

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.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'