VIEW: APPS.PAY_US_CITY_TAX_BAL_GRE_V

Source

View Text - Preformatted

SELECT BAL.BALANCE_SET_NAME BAL_SET_NAME, BAL.LEGISLATION_CODE LEGISLATION_CODE, BAL.ATTRIBUTE_1 BALANCE_NAME , BAL.ATTRIBUTE_2 TAX_CLASSIFICATION , BAL.ATTRIBUTE_3 WAGES_CLASSIFICATION , BAL.ATTRIBUTE_4 DIMENSION , BAL.ATTRIBUTE_5 REPORTING_NAME , ST.STATE_ABBREV STATE_ABBREV , ST.STATE_CODE STATE_CODE , CT.CITY_NAME CITY_NAME , CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE CITY_JD , TAX.TAX_UNIT_ID GRE_ID , PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2 , BAL.ATTRIBUTE_1 , 'EE' , 'PYDATE' , 'GRE' , TAX.TAX_UNIT_ID , CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE , -1 , NULL , NULL , NULL) CTD_TAX_VALUE , DECODE(BAL.ATTRIBUTE_1,'HT',0, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3 , BAL.ATTRIBUTE_1 , 'EE' , 'PYDATE' , 'GRE' , TAX.TAX_UNIT_ID , CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE , -1 , NULL , NULL , NULL)) CTD_WAGE_VALUE , DECODE(BAL.ATTRIBUTE_4,null,0, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2 , BAL.ATTRIBUTE_1 , 'EE' , BAL.ATTRIBUTE_4 , 'GRE' , TAX.TAX_UNIT_ID , CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE , -1 , NULL , NULL , NULL)) OTD_TAX_VALUE , DECODE(BAL.ATTRIBUTE_1,'HT',0, DECODE(BAL.ATTRIBUTE_4,null,0, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3 , BAL.ATTRIBUTE_1 , 'EE' , BAL.ATTRIBUTE_4 , 'GRE' , TAX.TAX_UNIT_ID , CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE , -1 , NULL , NULL , NULL))) OTD_WAGE_VALUE FROM PAY_US_CITY_NAMES CT , PAY_US_STATES ST , PAY_BALANCE_SETS BAL , PAY_US_TAX_UNIT_CITIES_V TAX WHERE CT.STATE_CODE = ST.STATE_CODE AND BAL.BALANCE_SET_NAME LIKE 'CITY_TRR%'AND CT.PRIMARY_FLAG = 'Y' AND SUBSTR(TAX.JURISDICTION_CODE,1,2) = CT.STATE_CODE AND SUBSTR(TAX.JURISDICTION_CODE,4,3) = CT.COUNTY_CODE AND SUBSTR(TAX.JURISDICTION_CODE,8,4) = CT.CITY_CODE AND PAY_US_PAYROLL_UTILS.GET_TAX_EXISTS(TAX.JURISDICTION_CODE,BAL.ATTRIBUTE_1) = 'Y'

View Text - HTML Formatted

SELECT BAL.BALANCE_SET_NAME BAL_SET_NAME
, BAL.LEGISLATION_CODE LEGISLATION_CODE
, BAL.ATTRIBUTE_1 BALANCE_NAME
, BAL.ATTRIBUTE_2 TAX_CLASSIFICATION
, BAL.ATTRIBUTE_3 WAGES_CLASSIFICATION
, BAL.ATTRIBUTE_4 DIMENSION
, BAL.ATTRIBUTE_5 REPORTING_NAME
, ST.STATE_ABBREV STATE_ABBREV
, ST.STATE_CODE STATE_CODE
, CT.CITY_NAME CITY_NAME
, CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE CITY_JD
, TAX.TAX_UNIT_ID GRE_ID
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE
, -1
, NULL
, NULL
, NULL) CTD_TAX_VALUE
, DECODE(BAL.ATTRIBUTE_1
, 'HT'
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE
, -1
, NULL
, NULL
, NULL)) CTD_WAGE_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_2
, BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE
, -1
, NULL
, NULL
, NULL)) OTD_TAX_VALUE
, DECODE(BAL.ATTRIBUTE_1
, 'HT'
, 0
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE ( BAL.ATTRIBUTE_3
, BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, CT.STATE_CODE||'-'||CT.COUNTY_CODE||'-'||CT.CITY_CODE
, -1
, NULL
, NULL
, NULL))) OTD_WAGE_VALUE
FROM PAY_US_CITY_NAMES CT
, PAY_US_STATES ST
, PAY_BALANCE_SETS BAL
, PAY_US_TAX_UNIT_CITIES_V TAX
WHERE CT.STATE_CODE = ST.STATE_CODE
AND BAL.BALANCE_SET_NAME LIKE 'CITY_TRR%'AND CT.PRIMARY_FLAG = 'Y'
AND SUBSTR(TAX.JURISDICTION_CODE
, 1
, 2) = CT.STATE_CODE
AND SUBSTR(TAX.JURISDICTION_CODE
, 4
, 3) = CT.COUNTY_CODE
AND SUBSTR(TAX.JURISDICTION_CODE
, 8
, 4) = CT.CITY_CODE
AND PAY_US_PAYROLL_UTILS.GET_TAX_EXISTS(TAX.JURISDICTION_CODE
, BAL.ATTRIBUTE_1) = 'Y'