328: --
329:
330: CURSOR csr_chk_plan_id IS
331: SELECT pmp.plan_id
332: FROM per_perf_mgmt_plans pmp
333: WHERE pmp.plan_id = p_plan_id;
334: --
335: BEGIN
336:
493: --
494:
495: CURSOR csr_dates_within_plan IS
496: SELECT pmp.start_date, pmp.end_date
497: FROM per_perf_mgmt_plans pmp
498: WHERE pmp.plan_id = p_plan_id;
499:
500: CURSOR csr_dates_within_template IS
501: SELECT apt.date_from, apt.date_to