APPS.PER_WPM_SUMMARY_PKG dependencies on PER_PERF_MGMT_PLANS

Line 81: FROM per_perf_mgmt_plans pmp,

77: ppf.person_id employee_id,
78: ppf2.full_name supervisor_name,
79: ppf2.person_id supervisor_id,
80: pmp.plan_id
81: FROM per_perf_mgmt_plans pmp,
82: per_assignments_f paf,
83: per_people_f ppf,
84: per_people_f ppf2
85: WHERE pmp.plan_id = p_plan_id

Line 188: FROM per_perf_mgmt_plans pmp

184: IS
185: CURSOR csr_plan_dtls (p_plan_id IN NUMBER)
186: IS
187: SELECT *
188: FROM per_perf_mgmt_plans pmp
189: WHERE plan_id = p_plan_id;
190:
191: --
192: l_pl_rec per_perf_mgmt_plans%ROWTYPE;

Line 192: l_pl_rec per_perf_mgmt_plans%ROWTYPE;

188: FROM per_perf_mgmt_plans pmp
189: WHERE plan_id = p_plan_id;
190:
191: --
192: l_pl_rec per_perf_mgmt_plans%ROWTYPE;
193:
194: --
195: CURSOR csr_sc_dtls (p_sc_id IN NUMBER)
196: IS

Line 236: ,per_perf_mgmt_plans pln

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
240: AND paf.supervisor_id = ppf2.person_id

Line 261: ,per_perf_mgmt_plans pln

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
265: AND paf.supervisor_id = ppf2.person_id

Line 287: ,per_perf_mgmt_plans pln

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
291: AND paf.supervisor_id = ppf2.person_id

Line 436: FROM per_perf_mgmt_plans pmp, per_assignments_f paf, per_people_f ppf, per_people_f ppf2

432: ppf.person_id employee_id,
433: ppf2.full_name supervisor_name,
434: ppf2.person_id supervisor_id,
435: pmp.plan_id plan_id
436: FROM per_perf_mgmt_plans pmp, per_assignments_f paf, per_people_f ppf, per_people_f ppf2
437: WHERE pmp.plan_id = p_plan_id
438: AND pmp.supervisor_id = paf.supervisor_id
439: AND paf.primary_flag = 'Y'
440: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date