eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_JOBS

Line 482: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960

478: SELECT COUNT(PEO.PERSON_ID)
479: INTO L_COUNT_EMPS
480: FROM PER_ALL_PEOPLE_F PEO,
481: PER_ALL_ASSIGNMENTS_F ASS,
482: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
483: PER_JOBS JOB
484: WHERE PEO.PERSON_ID = ASS.PERSON_ID
485: --
486: /* Commented for bug#11736960 starts

Line 483: PER_JOBS JOB

479: INTO L_COUNT_EMPS
480: FROM PER_ALL_PEOPLE_F PEO,
481: PER_ALL_ASSIGNMENTS_F ASS,
482: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
483: PER_JOBS JOB
484: WHERE PEO.PERSON_ID = ASS.PERSON_ID
485: --
486: /* Commented for bug#11736960 starts
487: AND PEO.PER_INFORMATION1 is not NULL

Line 742: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960

738: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
739: FROM
740: PER_ALL_PEOPLE_F PEO,
741: PER_ALL_ASSIGNMENTS_F ASS,
742: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
743: PER_JOBS JOB
744: WHERE PEO.PERSON_ID = ASS.PERSON_ID
745: --
746: /* Commented for bug#11736960 starts

Line 743: PER_JOBS JOB

739: FROM
740: PER_ALL_PEOPLE_F PEO,
741: PER_ALL_ASSIGNMENTS_F ASS,
742: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
743: PER_JOBS JOB
744: WHERE PEO.PERSON_ID = ASS.PERSON_ID
745: --
746: /* Commented for bug#11736960 starts
747: AND PEO.PER_INFORMATION1 is not NULL

Line 919: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL wth PER_JOBS - bug#11736960

915: INTO L_COUNT_EMPS
916: FROM
917: PER_ALL_ASSIGNMENTS_F ASS,
918: PER_ALL_PEOPLE_F PEO,
919: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL wth PER_JOBS - bug#11736960
920: PER_JOBS JOB
921: WHERE PEO.PERSON_ID = ASS.PERSON_ID
922: --
923: /* Commented for bug#11736960 starts

Line 920: PER_JOBS JOB

916: FROM
917: PER_ALL_ASSIGNMENTS_F ASS,
918: PER_ALL_PEOPLE_F PEO,
919: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL wth PER_JOBS - bug#11736960
920: PER_JOBS JOB
921: WHERE PEO.PERSON_ID = ASS.PERSON_ID
922: --
923: /* Commented for bug#11736960 starts
924: AND PEO.PER_INFORMATION1 is not NULL

Line 1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960

1238: ASS.JOB_ID
1239: FROM
1240: PER_ALL_PEOPLE_F PEO,
1241: PER_ALL_ASSIGNMENTS_F ASS,
1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
1243: PER_JOBS JOB,
1244: HR_LOCATIONS_ALL HL
1245: WHERE PEO.PERSON_ID = ASS.PERSON_ID
1246: --

Line 1243: PER_JOBS JOB,

1239: FROM
1240: PER_ALL_PEOPLE_F PEO,
1241: PER_ALL_ASSIGNMENTS_F ASS,
1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
1243: PER_JOBS JOB,
1244: HR_LOCATIONS_ALL HL
1245: WHERE PEO.PERSON_ID = ASS.PERSON_ID
1246: --
1247: /* Commented for bug#11736960 starts