View: PAYBV_US_LOCAL_ARCHIVE

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

View Text

SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.JURISDICTION_CODE
, PAY_AC_UTIL.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, SUBSTR(PAI.JURISDICTION_CODE
, 1
, 2) STATE_CODE
, PAY_AC_UTIL.GET_STATE_ABBREV(PAI.JURISDICTION_CODE) STATE_ABBREV
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION7))
, 0) LOCAL_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION1)
, 0) LOCAL_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) LOCAL_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) LOCAL_SUBJ_NWABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) LOCAL_PRE_TAX_REDNS
, (NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) ) LOCAL_SUBJECT
, (NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) ) LOCAL_REDUCED_SUBJECT
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, 0
, PAI.ACTION_INFORMATION5))
, 0) LOCAL_HEAD_TAX_LIABILITY
, NVL(TO_NUMBER(DECODE(PAI.ACTION_INFORMATION_CATEGORY
, 'US SCHOOL DISTRICT'
, 0
, PAI.ACTION_INFORMATION6))
, 0) LOCAL_HEAD_TAX_WITHHELD
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY IN ('US CITY'
, 'US COUNTY'
, 'US SCHOOL DISTRICT') WITH READ ONLY

Columns