How to find the Notification Workflow Message body, Attributes and other Information

How to find the Notification Workflow Message body, Attributes and other Information:

SELECT notification_id, message_name,item_Key FROM

WF_NOTIFICATIONS

WHERE NOTIFICATION_ID = 9202429

Message:

MessageName: HR_EMBD_NTFY_APPROVAL_FWD_MSG

ITEM_KEY =1734

Below Package is responsible for translation:

hr_workflow_ss.getProcessDisplayName

SELECT wrpv.display_name displayName

       --into getProcessDisplayName.lv_display_name

       FROM   wf_runnable_processes_v wrpv

       WHERE wrpv.item_type = 'HRSSA'

       AND wrpv.process_name = wf_engine.GetItemAttrText ('HRSSA','1734','PROCESS_NAME')

       AND rownum <=1;

alter session set NLS_LANGUAGE ='ARABIC' --'AMERICAN'--'

COMMIT      

Steps with screenshots:

1.


2.


3.


4.


5.


6.
 

7.