[Home] [Help]
View: PAY_APAC_PAYSLIP_ABSENCES_V
View Text
SELECT ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION4)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION5)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION6)
, HR_GENERAL_UTILITIES.GET_LOOKUP_MEANING('HOURS_OR_DAYS'
, SUBSTR(ACTION_INFORMATION7
, 1
, 1))
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION8)
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY = 'APAC ABSENCES'
Columns
Name |
ACTION_CONTEXT_ID |
ACTION_CONTEXT_TYPE |
ABSENCE_TYPE |
ELEMENT_REPORTING_NAME |
START_DATE |
END_DATE |
ABSENCE_VALUE |
UOM |
PAY_VALUE |