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 581: FROM per_appraisals pa,

577: )
578: IS
579: SELECT COUNT (*)
580: FROM (SELECT pa.appraisal_id
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

Line 610: FROM per_appraisals pa,

606: )
607: AND pa.overall_performance_level_id = p_rating_level_id
608: UNION
609: SELECT pa.appraisal_id
610: FROM per_appraisals pa,
611: per_wpm_plan_hierarchy wph,
612: per_people_f ppf,
613: per_all_assignments_f paf,
614: per_periods_of_placement pps

Line 650: FROM per_appraisals pa,

646: )
647: IS
648: SELECT COUNT (*)
649: FROM (SELECT pa.appraisal_id
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

Line 678: FROM per_appraisals pa,

674: )
675: AND pa.overall_performance_level_id = p_rating_level_id
676: UNION
677: SELECT pa.appraisal_id
678: FROM per_appraisals pa,
679: per_wpm_plan_hierarchy wph,
680: per_people_f ppf,
681: per_all_assignments_f paf,
682: per_periods_of_placement pps

Line 717: FROM per_appraisals pa,

713: )
714: IS
715: SELECT COUNT (*)
716: FROM (SELECT pa.appraisal_id
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

Line 746: FROM per_appraisals pa,

742: )
743: AND pa.overall_performance_level_id IS NULL
744: UNION
745: SELECT pa.appraisal_id
746: FROM per_appraisals pa,
747: per_wpm_plan_hierarchy wph,
748: per_people_f ppf,
749: per_all_assignments_f paf,
750: per_periods_of_placement pps

Line 784: FROM per_appraisals pa,

780: )
781: IS
782: SELECT COUNT (*)
783: FROM (SELECT pa.appraisal_id
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

Line 812: FROM per_appraisals pa,

808: )
809: AND pa.overall_performance_level_id IS NULL
810: UNION
811: SELECT pa.appraisal_id
812: FROM per_appraisals pa,
813: per_wpm_plan_hierarchy wph,
814: per_people_f ppf,
815: per_all_assignments_f paf,
816: per_periods_of_placement pps