eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_US_STATE_ACTION_INFO_V

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

View Text

SELECT PAI.JURISDICTION_CODE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_JURISDICTION_NAME(PAI.JURISDICTION_CODE) JURISDICTION_NAME
, PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, TO_NUMBER(PAI.ACTION_INFORMATION17) SIT_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION2 ) SIT_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION3 ) SIT_SUBJ_NWHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION4 ) 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
, TO_NUMBER(PAI.ACTION_INFORMATION1 ) SIT_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION26 ) SDI_EE_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION6 ) SDI_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION7 ) SDI_EE_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION8 ) SDI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION7 )
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION8 )
, 0) SDI_EE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION5 ) SDI_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION27 ) SDI_ER_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION10) SDI_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION11) SDI_ER_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION12) SDI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0) SDI_ER_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION9 ) SDI_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION28) SUI_EE_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION14) SUI_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION15) SUI_EE_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION16) SUI_EE_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION15)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION16)
, 0) SUI_EE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION13) SUI_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION29) SUI_ER_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION18) SUI_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION19) SUI_ER_SUBJ_WHABLE
, TO_NUMBER(PAI.ACTION_INFORMATION20) SUI_ER_PRE_TAX_REDNS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0) SUI_ER_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION21) SUI_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION22) WORKERS_COMP_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION23) WORKERS_COMP2_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION24) WORKERS_COMP2_ER
, TO_NUMBER(PAI.ACTION_INFORMATION25) WORKERS_COMP3_ER
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US STATE'

Columns

Name
JURISDICTION_CODE
JURISDICTION_NAME
ACTION_NUMBER
ASSIGNMENT_ID
EFFECTIVE_DATE
SIT_GROSS
SIT_SUBJ_WHABLE
SIT_SUBJ_NWHABLE
SIT_PRE_TAX_REDNS
SIT_SUBJECT
SIT_REDUCED_SUBJECT
SIT_WITHHELD
SDI_EE_GROSS
SDI_EE_TAXABLE
SDI_EE_SUBJ_WHABLE
SDI_EE_PRE_TAX_REDNS
SDI_EE_REDUCED_SUBJECT
SDI_EE_WITHHELD
SDI_ER_GROSS
SDI_ER_TAXABLE
SDI_ER_SUBJ_WHABLE
SDI_ER_PRE_TAX_REDNS
SDI_ER_REDUCED_SUBJECT
SDI_ER_LIABILITY
SUI_EE_GROSS
SUI_EE_TAXABLE
SUI_EE_SUBJ_WHABLE
SUI_EE_PRE_TAX_REDNS
SUI_EE_REDUCED_SUBJECT
SUI_EE_WITHHELD
SUI_ER_GROSS
SUI_ER_TAXABLE
SUI_ER_SUBJ_WHABLE
SUI_ER_PRE_TAX_REDNS
SUI_ER_REDUCED_SUBJECT
SUI_ER_LIABILITY
WORKERS_COMP_WITHHELD
WORKERS_COMP2_WITHHELD
WORKERS_COMP2_ER
WORKERS_COMP3_ER