Data model to Fetch Proposed value of Job in Workflow notification seeded Template

Content

Hi,

I have a requirement to add job title in Transfer Details section of seeded Workflow notification(Transfer Report).

I managed to fetch Current Value of Job but I am unable to fetch proposed value for job. 

I would really appreciate if someone can show how to fetch proposed value.

SQL to fetch current job title-

SELECT pjft.name    jobname
FROM   per_all_assignments_m asg,
   per_jobs_f_tl pjft
WHERE  asg.job_id = pjft.job_id
and ASG.ASSIGNMENT_ID = (SELECT
 extractValue(xmltype('<root>'||txndata.data_cache||'</root>'),'root/TRANSACTION/TransCtx/AssignmentId')
FROM hrc_txn_data txndata