DBA Data[Home] [Help]

APPS.PER_WPM_SUMMARY_PKG dependencies on PER_PERIODS_OF_PLACEMENT

Line 614: per_periods_of_placement pps

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
618: AND wph.employee_person_id = ppf.person_id

Line 682: per_periods_of_placement pps

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
686: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 750: per_periods_of_placement pps

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
754: AND wph.employee_person_id = ppf.person_id

Line 816: per_periods_of_placement pps

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
820: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date