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_ALL_PEOPLE_F

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 152: PER_ALL_PEOPLE_F PEO,

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,
155: PER_JOBS JOB,
156: HR_LOCATIONS_ALL HL

Line 174: -- Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960

170: AND PEO.EFFECTIVE_START_DATE = (
171: SELECT
172: MAX(PEO1.EFFECTIVE_START_DATE)
173: FROM
174: -- Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960
175: --PER_PEOPLE_F PEO1
176: PER_ALL_PEOPLE_F PEO1
177: WHERE L_DATE_START <= PEO1.EFFECTIVE_END_DATE
178: AND L_DATE_END >= PEO1.EFFECTIVE_START_DATE

Line 176: PER_ALL_PEOPLE_F PEO1

172: MAX(PEO1.EFFECTIVE_START_DATE)
173: FROM
174: -- Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F -bug#11736960
175: --PER_PEOPLE_F PEO1
176: PER_ALL_PEOPLE_F PEO1
177: WHERE L_DATE_START <= PEO1.EFFECTIVE_END_DATE
178: AND L_DATE_END >= PEO1.EFFECTIVE_START_DATE
179: AND PEO.PERSON_ID = PEO1.PERSON_ID
180: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )

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 296: PER_ALL_PEOPLE_F PEO,

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
299: PER_JOBS JOB
300: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 317: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F

313: AND PEO.EFFECTIVE_START_DATE = (
314: SELECT
315: MAX(PEO1.EFFECTIVE_START_DATE)
316: FROM
317: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
318: PER_ALL_PEOPLE_F PEO1
319: WHERE L_DATE_START <= PEO1.EFFECTIVE_END_DATE
320: AND L_DATE_END >= PEO1.EFFECTIVE_START_DATE
321: AND PEO.PERSON_ID = PEO1.PERSON_ID

Line 318: PER_ALL_PEOPLE_F PEO1

314: SELECT
315: MAX(PEO1.EFFECTIVE_START_DATE)
316: FROM
317: --PER_PEOPLE_F PEO1 - Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F
318: PER_ALL_PEOPLE_F PEO1
319: WHERE L_DATE_START <= PEO1.EFFECTIVE_END_DATE
320: AND L_DATE_END >= PEO1.EFFECTIVE_START_DATE
321: AND PEO.PERSON_ID = PEO1.PERSON_ID
322: AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y' )