How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIP

Hi ALL,

Kindly support me to resolve below issue:

I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report.

Following with other requirement I have built the query, please help me to add the above requirement in query attached below.

QUERY:

select person_number,ppnf.full_name,TO_CHAR(asg.effective_start_date,'DD-MON-YYYY') START_DATE, (SELECT NAME FROM PER_JOBS WHERE JOB_ID=ASG.JOB_ID ) Job,

asg.effective_end_date,PLDF.LOCATION_CODE

,PLDF.LOCATION_NAME,aor.person_id,

(SELECT DISTINCT pgft.name FROM PER_GRADES_F_TL pgft WHERE asg.grade_id=pgft.grade_id(+) AND LANGUAGE(+)='US') Officer_CD