[Home] [Help]
View: PAY_APAC_PAYSLIP_ELEMENTS_V
View Text
SELECT ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ACTION_INFORMATION1
, ACTION_INFORMATION4
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION5)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION6)
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION9)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION10)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION11)
, ACTION_INFORMATION12
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION13)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION14)
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY = 'APAC ELEMENTS'
Columns
Name |
ACTION_CONTEXT_ID |
ACTION_CONTEXT_TYPE |
ELEMENT_REPORTING_NAME |
ELEMENT_CLASSIFICATION |
CURRENT_AMOUNT |
YTD_AMOUNT |
CURRENT_HOURS |
YTD_HOURS |
RATE |
FX_RATE |
FX_AMOUNT |
FX_CURRENCY |
START_DATE |
END_DATE |