DBA Data[Home] [Help]

APPS.PER_WPM_SUMMARY_PKG dependencies on PER_ASSIGNMENTS_F

Line 61: ,per_assignments_f paf

57: ,ppf2.full_name supervisor_name
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

Line 188: ,per_assignments_f paf

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
191: AND sc.assignment_id = paf.assignment_id
192: AND paf.supervisor_id = ppf2.person_id

Line 305: ,per_assignments_f paf

301: ,ppf2.full_name supervisor_name
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