DBA Data[Home] [Help]

VIEW: APPS.PAY_IE_MESSAGE_V

Source

View Text - Preformatted

SELECT PAI_MSG.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID, PAI_MSG.ACTION_INFORMATION6 MESSAGE FROM PAY_ACTION_INFORMATION PAI_MSG WHERE PAI_MSG.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION' AND PAI_MSG.ACTION_CONTEXT_TYPE = 'PA'
View Text - HTML Formatted

SELECT PAI_MSG.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, PAI_MSG.ACTION_INFORMATION6 MESSAGE
FROM PAY_ACTION_INFORMATION PAI_MSG
WHERE PAI_MSG.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI_MSG.ACTION_CONTEXT_TYPE = 'PA'