APPS.PER_JP_WRKREG_REPORT_PKG dependencies on PER_JP_WRKREG_JOB_V

Line 1110: FROM per_jp_wrkreg_job_v PJWRGHV

1106: ,PJWRGHV.JOB
1107: ,PJWRGHV.START_DATE
1108: ,DECODE(PJWRGHV.END_DATE,TO_DATE('12/31/4712','mm/dd/yyyy'),null,PJWRGHV.END_DATE) END_DATE
1109: ,PJWRGHV.ORGANIZATION
1110: FROM per_jp_wrkreg_job_v PJWRGHV
1111: WHERE PJWRGHV.assignment_action_id = p_mag_asg_action_id
1112: ORDER BY PJWRGHV.START_DATE DESC,PJWRGHV.END_DATE DESC;
1113: --
1114: --Cursor to pick the Previous Job History of an Employee