APPS.PER_WPM_SUMMARY_PKG dependencies on PER_PERSONAL_SCORECARDS

Line 94: FROM per_personal_scorecards

90: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
91: AND paf.supervisor_id = ppf2.person_id
92: AND TRUNC (SYSDATE) BETWEEN ppf2.effective_start_date AND ppf2.effective_end_date
93: AND paf.person_id IN (SELECT person_id
94: FROM per_personal_scorecards
95: WHERE plan_id = p_plan_id);
96:
97: l_sup_level t_sup_level;
98: l_last NUMBER;

Line 201: FROM per_personal_scorecards sc, per_people_f ppf

197: SELECT sc.scorecard_id,
198: sc.person_id,
199: sc.assignment_id,
200: ppf.full_name
201: FROM per_personal_scorecards sc, per_people_f ppf
202: WHERE scorecard_id = p_sc_id
203: AND sc.person_id = ppf.person_id
204: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
205:

Line 213: FROM per_personal_scorecards sc, per_people_f ppf

209: SELECT sc.scorecard_id,
210: sc.person_id,
211: sc.assignment_id,
212: ppf.full_name
213: FROM per_personal_scorecards sc, per_people_f ppf
214: WHERE sc.plan_id = p_plan_id
215: AND sc.person_id = ppf.person_id
216: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
217:

Line 235: ,per_personal_scorecards sc

231: ,ppf.full_name "EMPLOYEE_NAME"
232: FROM per_people_f ppf
233: ,per_all_people_f ppf2
234: ,per_assignments_f paf
235: ,per_personal_scorecards sc
236: ,per_perf_mgmt_plans pln
237: WHERE sc.plan_id = p_plan_id
238: AND sc.plan_id = pln.plan_id
239: AND sc.assignment_id = paf.assignment_id

Line 260: ,per_personal_scorecards sc

256: ,ppf.full_name "EMPLOYEE_NAME"
257: FROM per_people_f ppf
258: ,per_all_people_f ppf2
259: ,per_assignments_f paf
260: ,per_personal_scorecards sc
261: ,per_perf_mgmt_plans pln
262: WHERE sc.plan_id = p_plan_id
263: AND sc.plan_id = pln.plan_id
264: AND sc.assignment_id = paf.assignment_id

Line 286: ,per_personal_scorecards sc

282: ,ppf.full_name "EMPLOYEE_NAME"
283: FROM per_people_f ppf
284: ,per_all_people_f ppf2
285: ,per_assignments_f paf
286: ,per_personal_scorecards sc
287: ,per_perf_mgmt_plans pln
288: WHERE sc.plan_id = p_plan_id
289: AND sc.plan_id = pln.plan_id
290: AND sc.assignment_id = paf.assignment_id

Line 446: FROM per_personal_scorecards

442: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
443: AND paf.supervisor_id = ppf2.person_id
444: AND p_effective_date BETWEEN ppf2.effective_start_date AND ppf2.effective_end_date
445: AND paf.person_id IN (SELECT person_id
446: FROM per_personal_scorecards
447: WHERE plan_id = p_plan_id);
448:
449: l_effective_date DATE;
450: l_sup_level t_sup_level;