[Home] [Help]
68: AND paf.person_id = ppf.person_id
69: AND trunc(sysdate) between ppf.effective_start_date AND ppf.effective_end_date
70: AND paf.supervisor_id = ppf2.person_id
71: AND trunc(sysdate) between ppf2.effective_start_date AND ppf2.effective_end_date
72: AND paf.person_id IN (select person_id FROM per_personal_scorecards WHERE plan_id = p_plan_id);
73: l_sup_level t_sup_level;
74: l_last NUMBER;
75: l_max_level NUMBER;
76: l_counter NUMBER;
152: SELECT sc.scorecard_id
153: ,sc.person_id
154: ,sc.assignment_id
155: ,ppf.full_name
156: FROM per_personal_scorecards sc,
157: per_people_f ppf
158: WHERE scorecard_id = p_sc_id
159: AND sc.person_id = ppf.person_id
160: AND trunc(sysdate) between ppf.effective_start_date AND
164: SELECT sc.scorecard_id
165: ,sc.person_id
166: ,sc.assignment_id
167: ,ppf.full_name
168: FROM per_personal_scorecards sc
169: ,per_people_f ppf
170: WHERE sc.plan_id = p_plan_id
171: AND sc.person_id = ppf.person_id
172: AND trunc(sysdate) between ppf.effective_start_date AND
185: ,ppf.full_name "EMPLOYEE_NAME"
186: FROM per_people_f ppf
187: ,per_all_people_f ppf2
188: ,per_assignments_f paf
189: ,per_personal_scorecards sc
190: WHERE sc.plan_id = p_plan_id
191: AND sc.assignment_id = paf.assignment_id
192: AND paf.supervisor_id = ppf2.person_id
193: AND paf.person_id = ppf.person_id
312: AND paf.person_id = ppf.person_id
313: AND p_effective_date between ppf.effective_start_date AND ppf.effective_end_date
314: AND paf.supervisor_id = ppf2.person_id
315: AND p_effective_date between ppf2.effective_start_date AND ppf2.effective_end_date
316: AND paf.person_id IN (select person_id FROM per_personal_scorecards WHERE plan_id = p_plan_id);
317: l_effective_date DATE;
318: l_sup_level t_sup_level;
319: l_proc VARCHAR2(80) := g_package||'populate_plan_hierarchy';
320: BEGIN