Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_COUNTY_ARCHIVE |
SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.JURISDICTION_CODE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, PAY_AC_UTIL.GET_STATE_ABBREV(PAI.JURISDICTION_CODE) STATE
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION7)
, 0) COUNTY_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION1)
, 0) COUNTY_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) COUNTY_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) COUNTY_SUBJ_NWABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) COUNTY_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) COUNTY_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0) COUNTY_REDUCED_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) HEAD_TAX_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION6)
, 0) HEAD_TAX_WITHHELD
, PAI.ACTION_INFORMATION30 NON_RESIDENT_FLAG
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US COUNTY' WITH READ ONLY