eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_WPM_SUMMARY_PKG dependencies on PER_PERF_MGMT_PLANS

Line 60: FROM per_perf_mgmt_plans pmp

56: ,ppf.person_id employee_id
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

Line 146: FROM per_perf_mgmt_plans pmp

142: PROCEDURE build_hierarchy_for_sc(p_plan_id IN NUMBER,
143: p_sc_id IN NUMBER DEFAULT NULL) IS
144: CURSOR csr_plan_dtls (p_plan_id IN NUMBER) IS
145: SELECT *
146: FROM per_perf_mgmt_plans pmp
147: WHERE plan_id = p_plan_id;
148: --
149: l_pl_rec per_perf_mgmt_plans%ROWTYPE;
150: --

Line 149: l_pl_rec per_perf_mgmt_plans%ROWTYPE;

145: SELECT *
146: FROM per_perf_mgmt_plans pmp
147: WHERE plan_id = p_plan_id;
148: --
149: l_pl_rec per_perf_mgmt_plans%ROWTYPE;
150: --
151: CURSOR csr_sc_dtls(p_sc_id IN NUMBER) IS
152: SELECT sc.scorecard_id
153: ,sc.person_id

Line 304: FROM per_perf_mgmt_plans pmp

300: ,ppf.person_id employee_id
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