How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!