How to Retrieve Unique Resignation Actions and Reasons

SELECT 
    ACTIONSB.ACTION_CODE AS A_CODE, 
    ACTIONS.ACTION_NAME AS A_NAME, 
    USAGES.ACTION_REASON_CODE AS U_REASON_CD, 
    REASONS.ACTION_REASON AS ACTION_REASON
FROM 
    PER_ACTIONS_B ACTIONSB
JOIN 
    PER_ACTIONS_TL ACTIONS ON ACTIONSB.ACTION_ID = ACTIONS.ACTION_ID
JOIN 
    PER_ACTION_TYPES_TL TYPES ON ACTIONSB.ACTION_TYPE_ID = TYPES.ACTION_TYPE_ID
LEFT JOIN 
    PER_ACTION_REASON_USAGES USAGES ON ACTIONSB.ACTION_ID = USAGES.ACTION_ID
LEFT JOIN 
    PER_ACTION_REASONS_B REASONSB ON USAGES.ACTION_REASON_ID = REASONSB.ACTION_REASON_ID
LEFT JOIN 
    PER_ACTION_REASONS_TL REASONS ON REASONSB.ACTION_REASON_ID = REASONS.ACTION_REASON_ID
WHERE 
    ACTIONS.ACTION_NAME = 'Resignation'
    AND ACTIONS.SOURCE_LANG = 'US'
    AND ACTIONS.LANGUAGE = 'US'
    AND TYPES.LANGUAGE = 'US'
GROUP BY 
    ACTIONSB.ACTION_CODE, 
    ACTIONS.ACTION_NAME, 
    USAGES.ACTION_REASON_CODE, 
    REASONS.ACTION_REASON

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.