[Home] [Help]
View: PAY_JP_PAYSLIP_ELEMENTS_V
View Text
SELECT PAI.ACTION_INFORMATION_ID
, PAI.OBJECT_VERSION_NUMBER
, PAI.ACTION_CONTEXT_ID
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION1)
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION2)
, PAI.ACTION_INFORMATION3
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION6 FROM PAY_ACTION_INFORMATION PAI WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ACTION_INFORMATION_CATEGORY = 'JP ELEMENT INFORMATION'
Columns
Name |
ACTION_INFORMATION_ID |
OBJECT_VERSION_NUMBER |
ASSIGNMENT_ACTION_ID |
ASSIGNMENT_ID |
EFFECTIVE_DATE |
ELEMENT_TYPE_ID |
INPUT_VALUE_ID |
REPORTING_NAME |
PAYMENT_TYPE |
UOM |
RESULT_VALUE |