APPS.PER_WPM_SUMMARY_PKG dependencies on PER_ASSIGNMENTS_F

Line 82: per_assignments_f paf,

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
86: AND paf.supervisor_id = p_supervisor_id

Line 234: ,per_assignments_f paf

230: ,paf.organization_id
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

Line 259: ,per_assignments_f paf

255: ,paf.organization_id
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

Line 285: ,per_assignments_f paf

281: ,paf.organization_id
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

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