APPS.PER_WPM_SUMMARY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 584: per_all_assignments_f paf,

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
586: WHERE wph.plan_id = p_plan_id
587: AND wph.supervisor_person_id = p_supervisor_id
588: AND wph.level_num = 1

Line 613: per_all_assignments_f paf,

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
615: WHERE wph.plan_id = p_plan_id
616: AND wph.supervisor_person_id = p_supervisor_id
617: AND wph.level_num = 1

Line 653: per_all_assignments_f paf,

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
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

Line 681: per_all_assignments_f paf,

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
683: WHERE wph.plan_id = p_plan_id
684: AND wph.supervisor_person_id = p_supervisor_id
685: AND wph.employee_person_id = ppf.person_id

Line 720: per_all_assignments_f paf,

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
722: WHERE wph.plan_id = p_plan_id
723: AND wph.supervisor_person_id = p_supervisor_id
724: AND wph.level_num = 1

Line 749: per_all_assignments_f paf,

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
751: WHERE wph.plan_id = p_plan_id
752: AND wph.supervisor_person_id = p_supervisor_id
753: AND wph.level_num = 1

Line 787: per_all_assignments_f paf,

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
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

Line 815: per_all_assignments_f paf,

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
817: WHERE wph.plan_id = p_plan_id
818: AND wph.supervisor_person_id = p_supervisor_id
819: AND wph.employee_person_id = ppf.person_id