Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_US_FEDERAL_ACTION_INFO_V |
SELECT PAI.ACTION_CONTEXT_ID ACTION_NUMBER
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, TO_NUMBER(PAI.ACTION_INFORMATION23) FIT_GROSS
, TO_NUMBER(PAI.ACTION_INFORMATION1 ) FIT_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION2 ) REGULAR_EARNINGS
, TO_NUMBER(PAI.ACTION_INFORMATION3 ) SUPPLEMENTAL_EARNINGS_FOR_FIT
, TO_NUMBER(PAI.ACTION_INFORMATION4 ) SUPP_EARNINGS_FOR_NWFIT
, TO_NUMBER(PAI.ACTION_INFORMATION5 ) PRE_TAX_DEDUCTIONS
, TO_NUMBER(PAI.ACTION_INFORMATION6 ) PRE_TAX_DEDUCTIONS_FOR_FIT
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) FIT_SUBJECT_WHABLE
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION3)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION4)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION6)
, 0))) FIT_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION7 ) SS_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION8 ) SS_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION9 ) SS_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION10) SS_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION11) SUPPLEMENTAL_EARNINGS_FOR_SS
, TO_NUMBER(PAI.ACTION_INFORMATION12) PRE_TAX_DEDUCTIONS_FOR_SS
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0) SS_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION11)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION12)
, 0))) SS_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION13) MEDICARE_EE_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION14) MEDICARE_EE_WITHHELD
, TO_NUMBER(PAI.ACTION_INFORMATION15) MEDICARE_ER_LIABILITY
, TO_NUMBER(PAI.ACTION_INFORMATION16) MEDICARE_ER_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION17) SUPP_EARNINGS_FOR_MEDICARE
, TO_NUMBER(PAI.ACTION_INFORMATION18) PRE_TAX_DEDUCT_FOR_MEDICARE
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0) MEDICARE_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION17)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION18)
, 0))) MEDICARE_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION19) SUPP_EARNINGS_FOR_FUTA
, TO_NUMBER(PAI.ACTION_INFORMATION20) PRE_TAX_DEDUCT_FOR_FUTA
, TO_NUMBER(PAI.ACTION_INFORMATION21) FUTA_TAXABLE
, TO_NUMBER(PAI.ACTION_INFORMATION22) FUTA_LIABILITY
, NVL(TO_NUMBER(PAI.ACTION_INFORMATION2 )
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0) FUTA_SUBJECT
, ((NVL(TO_NUMBER(PAI.ACTION_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAI.ACTION_INFORMATION19)
, 0)) - (NVL(TO_NUMBER(PAI.ACTION_INFORMATION5)
, 0) - NVL(TO_NUMBER(PAI.ACTION_INFORMATION20)
, 0))) FUTA_REDUCED_SUBJECT
, TO_NUMBER(PAI.ACTION_INFORMATION26) EIC_ADVANCE
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'US FEDERAL'