346: ASS.JOB_ID
347: FROM
348: PER_ALL_PEOPLE_F PEO,
349: PER_ASSIGNMENTS_F ASS,
350: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
351: PER_JOBS JOB,
352: HR_LOCATIONS_ALL LOC
353: WHERE PEO.PERSON_ID = ASS.PERSON_ID
354: --
347: FROM
348: PER_ALL_PEOPLE_F PEO,
349: PER_ASSIGNMENTS_F ASS,
350: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
351: PER_JOBS JOB,
352: HR_LOCATIONS_ALL LOC
353: WHERE PEO.PERSON_ID = ASS.PERSON_ID
354: --
355: /* Commented for bug#11736960 starts