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_PERUSEOC_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 349: PER_ASSIGNMENTS_F ASS,

345: JOB.NAME JOB_NAME,
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

Line 380: PER_ASSIGNMENTS_F ASS1,

376: AND ASS.EFFECTIVE_START_DATE = (
377: SELECT
378: MAX(ASS1.EFFECTIVE_START_DATE)
379: FROM
380: PER_ASSIGNMENTS_F ASS1,
381: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
382: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
383: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
384: AND ASS.PERSON_ID = ASS1.PERSON_ID