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'
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'
|
|
|