[Home] [Help]
View: PAY_APAC_PAYSLIP_BALANCES2_V
View Text
SELECT ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ACTION_INFORMATION1
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION4)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION5)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION6)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION7)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION8)
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY = 'APAC BALANCES 2'
Columns
Name |
ACTION_CONTEXT_ID |
ACTION_CONTEXT_TYPE |
BALANCE_NAME |
RUN_VALUE |
YTD_VALUE |
START_DATE |
END_DATE |
RELEVANT_INCOME |