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_PERIODS_OF_SERVICE

Line 585: per_periods_of_service pps

581: FROM per_appraisals pa,
582: per_wpm_plan_hierarchy wph,
583: per_people_f ppf,
584: per_all_assignments_f paf,
585: per_periods_of_service pps
586: WHERE wph.plan_id = p_plan_id
587: AND wph.supervisor_person_id = p_supervisor_id
588: AND wph.level_num = 1
589: AND wph.employee_person_id = ppf.person_id

Line 654: per_periods_of_service pps

650: FROM per_appraisals pa,
651: per_wpm_plan_hierarchy wph,
652: per_people_f ppf,
653: per_all_assignments_f paf,
654: per_periods_of_service pps
655: WHERE wph.plan_id = p_plan_id
656: AND wph.supervisor_person_id = p_supervisor_id
657: AND wph.employee_person_id = ppf.person_id
658: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 721: per_periods_of_service pps

717: FROM per_appraisals pa,
718: per_wpm_plan_hierarchy wph,
719: per_people_f ppf,
720: per_all_assignments_f paf,
721: per_periods_of_service pps
722: WHERE wph.plan_id = p_plan_id
723: AND wph.supervisor_person_id = p_supervisor_id
724: AND wph.level_num = 1
725: AND wph.employee_person_id = ppf.person_id

Line 788: per_periods_of_service pps

784: FROM per_appraisals pa,
785: per_wpm_plan_hierarchy wph,
786: per_people_f ppf,
787: per_all_assignments_f paf,
788: per_periods_of_service pps
789: WHERE wph.plan_id = p_plan_id
790: AND wph.supervisor_person_id = p_supervisor_id
791: AND wph.employee_person_id = ppf.person_id
792: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date