Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_STATE_ARCHIVE |
SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.JURISDICTION_CODE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0) SIT_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) SIT_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION3 )
, 0) SIT_SUBJ_NWHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION4 )
, 0) SIT_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3 )
, 0) SIT_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION4 )
, 0) SIT_REDUCED_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION1 )
, 0) SIT_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION26 )
, 0) SDI_EE_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION6 )
, 0) SDI_EE_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION7 )
, 0) SDI_EE_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION8 )
, 0) SDI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION7 )
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION8 )
, 0) SDI_EE_REDUCED_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION5 )
, 0) SDI_EE_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION27 )
, 0) SDI_ER_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION10)
, 0) SDI_ER_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) SDI_ER_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0) SDI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0) SDI_ER_REDUCED_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION9 )
, 0) SDI_ER_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION28)
, 0) SUI_EE_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION14)
, 0) SUI_EE_TAXABLE
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION15)
, 0) SUI_EE_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION16)
, 0) SUI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION15)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION16)
, 0) SUI_EE_REDUCED_SUBJECT
, NVL( TO_NUMBER(PAI.ACTION_INFORMATION13)
, 0) SUI_EE_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION29)
, 0) SUI_ER_GROSS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION18)
, 0) SUI_ER_TAXABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) SUI_ER_SUBJ_WHABLE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0) SUI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0) SUI_ER_REDUCED_SUBJECT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION21)
, 0) SUI_ER_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION22)
, 0) WORKERS_COMP_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION23)
, 0) WORKERS_COMP2_WITHHELD
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION24)
, 0) WORKERS_COMP2_ER
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION25)
, 0) WORKERS_COMP3_ER
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US STATE' WITH READ ONLY