Grade to be visible on Transfer page

Hi All,

We are trying to Fetch the grade of the respective worker in the Transfer page from the assignment details.

For this we created a read only DFF, and in Initial Default section we used the following query to fetch the value:

SELECT SUBSTR(pg.Name,0,120)

                        

From PER_ALL_ASSIGNMENTS_M A,PER_GRADES Pg

Where 1=1

and pg.Grade_id = a.Grade_id

AND ACTIVE_STATUS = 'A'

        AND sysdate BETWEEN pg.effective_start_date AND

                  pg.effective_end_date

AND A.PERSON_ID=:{PARAMETER.PERSON_ID}

-- in (SELECT PERSON_ID from PER_ALL_PEOPLE_F where person_number='212717436')