VIEW: APPS.PAY_CA_FEDERAL_TAX_BAL_GRE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'