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_PERUSE1L_XMLP_PKG dependencies on PER_JOBS

Line 149: /* Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL

145: JOB.NAME JOB_NAME,
146: ASS.LOCATION_ID,
147: HL.LOCATION_CODE
148: FROM
149: /* Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL
150: with PER_JOBS - bug#11736960 */
151: --PER_PEOPLE_F PEO
152: PER_ALL_PEOPLE_F PEO,
153: PER_ASSIGNMENTS_F ASS,

Line 150: with PER_JOBS - bug#11736960 */

146: ASS.LOCATION_ID,
147: HL.LOCATION_CODE
148: FROM
149: /* Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL
150: with PER_JOBS - bug#11736960 */
151: --PER_PEOPLE_F PEO
152: PER_ALL_PEOPLE_F PEO,
153: PER_ASSIGNMENTS_F ASS,
154: --PER_JOBS_VL JOB,

Line 154: --PER_JOBS_VL JOB,

150: with PER_JOBS - bug#11736960 */
151: --PER_PEOPLE_F PEO
152: PER_ALL_PEOPLE_F PEO,
153: PER_ASSIGNMENTS_F ASS,
154: --PER_JOBS_VL JOB,
155: PER_JOBS JOB,
156: HR_LOCATIONS_ALL HL
157: WHERE PEO.PERSON_ID = ASS.PERSON_ID
158: --

Line 155: PER_JOBS JOB,

151: --PER_PEOPLE_F PEO
152: PER_ALL_PEOPLE_F PEO,
153: PER_ASSIGNMENTS_F ASS,
154: --PER_JOBS_VL JOB,
155: PER_JOBS JOB,
156: HR_LOCATIONS_ALL HL
157: WHERE PEO.PERSON_ID = ASS.PERSON_ID
158: --
159: /* Commented for bug#11736960 starts

Line 294: --Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL with PER_JOBS

290: SELECT
291: COUNT('X')
292: INTO L_REPORT_EMPS
293: FROM
294: --Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL with PER_JOBS
295: --PER_PEOPLE_F PEO,
296: PER_ALL_PEOPLE_F PEO,
297: PER_ASSIGNMENTS_F ASS,
298: --PER_JOBS_VL JOB

Line 298: --PER_JOBS_VL JOB

294: --Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL with PER_JOBS
295: --PER_PEOPLE_F PEO,
296: PER_ALL_PEOPLE_F PEO,
297: PER_ASSIGNMENTS_F ASS,
298: --PER_JOBS_VL JOB
299: PER_JOBS JOB
300: WHERE PEO.PERSON_ID = ASS.PERSON_ID
301: --
302: /* Commented for bug#11736960 starts

Line 299: PER_JOBS JOB

295: --PER_PEOPLE_F PEO,
296: PER_ALL_PEOPLE_F PEO,
297: PER_ASSIGNMENTS_F ASS,
298: --PER_JOBS_VL JOB
299: PER_JOBS JOB
300: WHERE PEO.PERSON_ID = ASS.PERSON_ID
301: --
302: /* Commented for bug#11736960 starts
303: AND PEO.PER_INFORMATION1 is not null

Line 417: --Replaced PER_JOBS_VL with PER_JOBS -bug#11736960

413: COUNT('X')
414: INTO L_COUNT_EMPS
415: FROM
416: PER_ASSIGNMENTS_F ASS,
417: --Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
418: --PER_JOBS_VL JOB
419: PER_JOBS JOB
420: WHERE JOB.JOB_INFORMATION_CATEGORY = 'US'
421: AND L_DATE_START <= NVL(JOB.DATE_TO

Line 418: --PER_JOBS_VL JOB

414: INTO L_COUNT_EMPS
415: FROM
416: PER_ASSIGNMENTS_F ASS,
417: --Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
418: --PER_JOBS_VL JOB
419: PER_JOBS JOB
420: WHERE JOB.JOB_INFORMATION_CATEGORY = 'US'
421: AND L_DATE_START <= NVL(JOB.DATE_TO
422: ,L_DATE_END)

Line 419: PER_JOBS JOB

415: FROM
416: PER_ASSIGNMENTS_F ASS,
417: --Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
418: --PER_JOBS_VL JOB
419: PER_JOBS JOB
420: WHERE JOB.JOB_INFORMATION_CATEGORY = 'US'
421: AND L_DATE_START <= NVL(JOB.DATE_TO
422: ,L_DATE_END)
423: AND L_DATE_END >= JOB.DATE_FROM