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_WPM_SUMMARY_PKG dependencies on PER_APPRAISALS

Line 433: FROM per_appraisals pa

429: ,p_supervisor_id NUMBER
430: ,p_effective_date DATE
431: ,p_rating_level_id NUMBER) IS
432: SELECT COUNT(*)
433: FROM per_appraisals pa
434: ,per_wpm_plan_hierarchy wph
435: ,per_people_f ppf
436: WHERE wph.plan_id = p_plan_id
437: AND wph.supervisor_person_id = p_supervisor_id

Line 453: FROM per_appraisals pa

449: ,p_supervisor_id NUMBER
450: ,p_effective_date DATE
451: ,p_rating_level_id NUMBER) IS
452: SELECT COUNT(*)
453: FROM per_appraisals pa
454: ,per_wpm_plan_hierarchy wph
455: ,per_people_f ppf
456: WHERE wph.plan_id = p_plan_id
457: AND wph.supervisor_person_id = p_supervisor_id

Line 471: FROM per_appraisals pa

467: CURSOR csr_directs_unrated(p_plan_id NUMBER
468: ,p_supervisor_id NUMBER
469: ,p_effective_date DATE) IS
470: SELECT COUNT(*)
471: FROM per_appraisals pa
472: ,per_wpm_plan_hierarchy wph
473: ,per_people_f ppf
474: WHERE wph.plan_id = p_plan_id
475: AND wph.level_num = 1

Line 488: FROM per_appraisals pa

484: CURSOR csr_total_unrated(p_plan_id NUMBER
485: ,p_supervisor_id NUMBER
486: ,p_effective_date DATE) IS
487: SELECT COUNT(*)
488: FROM per_appraisals pa
489: ,per_wpm_plan_hierarchy wph
490: ,per_people_f ppf
491: WHERE wph.plan_id = p_plan_id
492: AND wph.supervisor_person_id = p_supervisor_id