SELECT action_context_id, action_context_type, action_information1, fnd_number.canonical_to_number(action_information4), fnd_number.canonical_to_number(action_information5) from pay_action_information where action_context_type = 'AAP' and action_information_category = 'APAC BALANCES' order by action_information_id
SELECT ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ACTION_INFORMATION1
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION4)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION5)
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY = 'APAC BALANCES' ORDER BY ACTION_INFORMATION_ID
|
|
|