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_JP_WL_YEA_INFO_V

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

View Text

SELECT ROWID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION1)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION2)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION3)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION4)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION5)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION6)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION7)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION8)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION9)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION10)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION11)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION12)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION13)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION14)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION15)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION16)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION17)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION18)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION19)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION20)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION21)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION22)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION23)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION24)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION25)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION26)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION27)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION28)
, FND_NUMBER.CANONICAL_TO_NUMBER (ACTION_INFORMATION29)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY = 'JP_WL_YEA_INFO'

Columns

Name
ROW_ID
ACTION_INFORMATION_ID
OBJECT_VERSION_NUMBER
ASSIGNMENT_ACTION_ID
ACTION_CONTEXT_TYPE
ASSIGNMENT_ID
EFFECTIVE_DATE
ACTION_INFORMATION_CATEGORY
PERSON_ID
SAL_AMT
BON_AMT
TAXABLE_INCOME
SAL_TAX
BON_TAX
NET_INCOME
SI_DEDUCTION
SI_PREM
DEP_EXEMPTION
LI_PREM
EI_PREM
SPOUSE_SP_EXEMPT
SPOUSE_INCOME
PP_PREM
LONG_TERM_AI_PREM
MUTUAL_AID_PREM
NPI_PREMIUM
HOUSING_LOAN_DEDUCTION
YEA_ANNUAL_TAX
OVER_AND_SHORT_TAX
DEP_SPOUSE_EXEMPTION
DEPENDENT_EXEMPTION
BASIS_EXEMPTION
DEP_DISABLED_EXEMPTION
TOTAL_SE_DE_BE_DISE
TOTAL_INCOME_DEDUCTION
NET_ASS_SAL_INCOME_MONEY
CALCULATED_TAX
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE