[Home] [Help]
58: ,ppf2.person_id supervisor_id
59: ,pmp.plan_id
60: FROM per_perf_mgmt_plans pmp
61: ,per_assignments_f paf
62: ,per_people_f ppf
63: ,per_people_f ppf2
64: WHERE pmp.plan_id = p_plan_id
65: AND paf.supervisor_id = p_supervisor_id
66: AND paf.primary_flag = 'Y'
59: ,pmp.plan_id
60: FROM per_perf_mgmt_plans pmp
61: ,per_assignments_f paf
62: ,per_people_f ppf
63: ,per_people_f ppf2
64: WHERE pmp.plan_id = p_plan_id
65: AND paf.supervisor_id = p_supervisor_id
66: AND paf.primary_flag = 'Y'
67: AND trunc(sysdate) between paf.effective_start_date AND paf.effective_end_date
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
161: ppf.effective_end_date;
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
173: ppf.effective_end_date;
182: ,ppf2.full_name "SUPERVISOR_NAME"
183: ,paf.position_id
184: ,paf.organization_id
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
203: TYPE r_sc_hrchy IS RECORD (level NUMBER(15)
204: ,assignment_id number(15)
205: ,person_id number(15)
206: ,supervisor_id number(15)
207: ,supervisor_name per_people_f.full_name%TYPE
208: ,position_id number(15)
209: ,organization_id number(15)
210: ,employee_name per_people_f.full_name%TYPE);
211: TYPE t_sc_hrchy IS TABLE OF r_sc_hrchy INDEX BY BINARY_INTEGER;
206: ,supervisor_id number(15)
207: ,supervisor_name per_people_f.full_name%TYPE
208: ,position_id number(15)
209: ,organization_id number(15)
210: ,employee_name per_people_f.full_name%TYPE);
211: TYPE t_sc_hrchy IS TABLE OF r_sc_hrchy INDEX BY BINARY_INTEGER;
212: l_sc_hrchy t_sc_hrchy;
213: BEGIN
214: OPEN csr_plan_dtls(p_plan_id);
302: ,ppf2.person_id supervisor_id
303: ,pmp.plan_id PLAN_ID
304: FROM per_perf_mgmt_plans pmp
305: ,per_assignments_f paf
306: ,per_people_f ppf
307: ,per_people_f ppf2
308: WHERE pmp.plan_id = p_plan_id
309: AND pmp.supervisor_id = paf.supervisor_id
310: AND paf.primary_flag = 'Y'
303: ,pmp.plan_id PLAN_ID
304: FROM per_perf_mgmt_plans pmp
305: ,per_assignments_f paf
306: ,per_people_f ppf
307: ,per_people_f ppf2
308: WHERE pmp.plan_id = p_plan_id
309: AND pmp.supervisor_id = paf.supervisor_id
310: AND paf.primary_flag = 'Y'
311: AND p_effective_date between paf.effective_start_date AND paf.effective_end_date
431: ,p_rating_level_id NUMBER) IS
432: SELECT COUNT(*)
433: FROM per_appraisals pa
434: ,per_wpm_plan_hierarchy wph
435: ,per_people_f ppf
436: WHERE wph.plan_id = p_plan_id
437: AND wph.supervisor_person_id = p_supervisor_id
438: AND wph.level_num = 1
439: AND wph.employee_person_id = ppf.person_id
451: ,p_rating_level_id NUMBER) IS
452: SELECT COUNT(*)
453: FROM per_appraisals pa
454: ,per_wpm_plan_hierarchy wph
455: ,per_people_f ppf
456: WHERE wph.plan_id = p_plan_id
457: AND wph.supervisor_person_id = p_supervisor_id
458: AND wph.employee_person_id = ppf.person_id
459: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
469: ,p_effective_date DATE) IS
470: SELECT COUNT(*)
471: FROM per_appraisals pa
472: ,per_wpm_plan_hierarchy wph
473: ,per_people_f ppf
474: WHERE wph.plan_id = p_plan_id
475: AND wph.level_num = 1
476: AND wph.supervisor_person_id = p_supervisor_id
477: AND wph.employee_person_id = ppf.person_id
486: ,p_effective_date DATE) IS
487: SELECT COUNT(*)
488: FROM per_appraisals pa
489: ,per_wpm_plan_hierarchy wph
490: ,per_people_f ppf
491: WHERE wph.plan_id = p_plan_id
492: AND wph.supervisor_person_id = p_supervisor_id
493: AND wph.employee_person_id = ppf.person_id
494: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date