View: PAY_CA_FEDERAL_TAX_BAL_GRE_V

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

View Text

SELECT BAL.BALANCE_SET_NAME BALANCE_SET_NAME
, BAL.LEGISLATION_CODE LEGISLATION_CODE
, BAL.ATTRIBUTE_1 WAGE_BALANCE_NAME
, BAL.ATTRIBUTE_2 TAX_BALANCE_NAME
, BAL.ATTRIBUTE_3 DIMENSION
, BAL.ATTRIBUTE_4 REPORTING_NAME
, BAL.ATTRIBUTE_5 FORMAT_CODE
, TAX.TAX_UNIT_ID TAX_UNIT_ID
, TAX.NAME GRE_NAME
, OIN.ORG_INFORMATION4 TAX_GROUP_ID
, AOU.NAME TAX_GROUP_NAME
, TAX.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OIN.ORG_INFORMATION1 BUSINESS_NO
, SES.SESSION_ID SESSION_ID
, SES.EFFECTIVE_DATE EFFECTIVE_DATE
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE (BAL.ATTRIBUTE_1
, 'PYDATE'
, SES.EFFECTIVE_DATE
, NULL
, NULL
, TAX.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL
, NULL) TAX_CTD_VALUE
, DECODE(BAL.ATTRIBUTE_2
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE (BAL.ATTRIBUTE_2
, 'PYDATE'
, SES.EFFECTIVE_DATE
, NULL
, NULL
, TAX.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL
, NULL)) WAGE_CTD_VALUE
, DECODE(BAL.ATTRIBUTE_3
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE (BAL.ATTRIBUTE_1
, BAL.ATTRIBUTE_3
, SES.EFFECTIVE_DATE
, NULL
, NULL
, TAX.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL
, NULL)) TAX_OTD_VALUE
, DECODE(BAL.ATTRIBUTE_3
, NULL
, 0
, DECODE(BAL.ATTRIBUTE_2
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE (BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_3
, SES.EFFECTIVE_DATE
, NULL
, NULL
, TAX.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL
, NULL))) WAGE_OTD_VALUE
FROM HR_ORGANIZATION_INFORMATION OIN
, HR_ALL_ORGANIZATION_UNITS AOU
, PAY_BALANCE_SETS BAL
, HR_CA_TAX_UNITS_V TAX
, FND_SESSIONS SES
WHERE OIN.ORGANIZATION_ID = TAX.TAX_UNIT_ID
AND OIN.ORG_INFORMATION_CONTEXT||'' = 'CANADA EMPLOYER IDENTIFICATION'
AND AOU.ORGANIZATION_ID (+) = TO_NUMBER(OIN.ORG_INFORMATION4)
AND BAL.LEGISLATION_CODE = 'CA'

Columns